DATA INSIGHT TRAINING
  • Home
  • On-Site Training
    • Power BI Master Class
    • Excel BI Boot Camp
    • Interactive Dashboards with Excel Pivot Tables
  • Online & Virtual Training
    • Our Courses
    • Affiliate Courses
  • About Us
  • Blog

A Complete Introduction to Power BI

25/11/2019

0 Comments

 
Over the course of the next few weeks we're going to be releasing a series of videos in our "Complete Introduction to" series.  The idea behind the series is to provide a comprehensive introduction to a variety of different data analysis and business intelligence tools and techniques so that business users can fully understand the tools available to them, and how they can work smarter not harder.

The first video for the series will introduce you to Microsoft Power BI.  

​One of the biggest selling points of Microsoft Power BI is that, because it's based on the Excel platform, the millions of Excel users working with data on a daily basis will find it easy to navigate and not be intimidated by this incredibly powerful tool. 


You will see how quickly and easily I produce an interactive report from an Excel spreadsheet using Microsoft Power BI.  An Excel spreadsheet of Sales data has been used as the source of the data, but data from many different sources such as databases, .csv and Web sources can just as easily be used.

​In the video you'll see how easy it is to format tables of data, perform more advanced functions, like cross filtering, and add visualisations, such as column charts, line graphs and pie graphs, resulting in a detailed, interactive sales report emerging in minutes!

The Microsoft Power BI Query Editor gives you a wide variety of options that allow you to transform, manipulate and prepare your data.  It allows for perform simple and advanced tasks such as:
  • easily remove fields
  • change data types
  • filter data
  • replace data
  • merging data
  • appending data
  • grouping data
  • adding new calculations
  • pivoting and unpivoting data
A big component of Power BI is it's unique programming formula language called DAX but don't be put off because, as I said at the beginning, Power BI is based on Excel, so many of the DAX formulas are the same and when you start using Power BI you should find yourself picking it up very quickly. 
At the end of the video I show you how to publish the report into the Power BI Service.  The Power BI Service allows you to share the report to other users using a web browser, smartphones or tablets.  I also show how to create a dashboard in the Power BI Service which makes it easier to access your content through mobile devices. 

Last but not least, I demonstrate how to use natural language queries (Q&A) to ask questions of your data.  This powerful feature allows you to type in questions in a natural way and have Power BI provide the answers to them.  I can ask 'What is my total Sales?' or 'What is my Sales in Italy?'and take it even further by asking 'What is my Sales by Product Category in Italy as a Column graph?   This function fundamentally changes that way that users can interact and ask questions of their data. 
I hope that you enjoy this video and look forward to sharing the next one with you.  If you are looking for Power BI training, please have a look at our Power BI Master Class and Excel BI Boot Camp.
0 Comments

    Categories

    All
    Business Data Analysis
    Complete Introduction To
    Coronavirus
    Data Skills
    DAX
    Excel Dashboards
    Excel Formulas
    Gartner Report
    Inspiration & Motivation
    Pivot Tables
    Power BI
    Power BI Desktop
    Power BI Query Editor
    Power BI Services
    Power Map
    Power Pivot
    Power Query
    Power View
    Tables & Reports

    Archives

    April 2020
    March 2020
    February 2020
    January 2020
    December 2019
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017

Privacy Policy
Copyright datainsighttraining.com
info@datainsighttraining.com
+44 330 223 5910
  • Home
  • On-Site Training
    • Power BI Master Class
    • Excel BI Boot Camp
    • Interactive Dashboards with Excel Pivot Tables
  • Online & Virtual Training
    • Our Courses
    • Affiliate Courses
  • About Us
  • Blog