2 Day Microsoft Power BI Bootcamp: Data Visualization and Science

Toronto Campus

GA Toronto
220 King St W, 3rd Floor
Toronto ON M5H 1K4

2 Day Microsoft Power BI Bootcamp: Data Visualization and Science | Toronto

Toronto Campus

GA Toronto
220 King St W, 3rd Floor
Toronto ON M5H 1K4

About this workshop series

Power BI is Microsoft self-service business analytics and data visualization tool that delivers deep insights to enable fast, informed decisions. Power BI is recognized as a leader in Analytics and Enterprise BI platforms. Gartner recognizes Microsoft as a Leader in the Analytics and Business Intelligence Platforms Magic Quadrant for the twelfth consecutive year. Forrester recognizes Microsoft as a Leader in the Forrester Wave™: Enterprise BI Platforms (Vendor-Managed), Q3 2019.

During this two-day bootcamp, you will learn the fundamental skills to know how to use Power BI to build highly interactive visualization and dashboards form end to end; getting the data from various sources, data preparation, data cleansing, data modelling and relationships, adding measures and calculations, visualization, explore data and get insights and eventually purplish and share dashboards.

You will also learn about the emerging role of Citizen Data Scientist as defined by Gartner as “A person who creates machine learning model that use advanced diagnostic, predictive, and prescriptive capabilities, but whose primary job function is outside the field of statistics and data science.

Gartner predicts that 40% of data science tasks will be automated by 2020 and as a result the number of Citizen Data Scientists will grow five times faster than the number of expert data scientists to fill the data science and machine learning talent gap caused by the shortage and high cost of data scientists. Citizen Data Scientists will surpass data scientists in the amount of advanced analysis produced.

Takeaways

Day 1: 6 Hrs. Visual Analytics – Prepare, Model, Visualize and Explore Data

  • Access data from different sources using Power Query
  • Prepare, clean and manipulate your data
  • Build the data model and relationships
  • Enhance data model through DAX columns and measures
  • Get insights through advanced visual analytics capabilities
  • Visualize, explore, publish and share dashboards 

    Day 2: 6 Hrs. Data Science – Machine Learning and AI Cognitive Services

  • Introduction to Data Science, Machine Learning and AI
  • Options of doing Machine Learning using Power BI
  • Integration with Python/R
  • Introduction to Azure Machine Learning Studio
  • Auto Machine Learning in Power BI (Premium)
  • AI Cognitive Services in Power BI (Premium)

    By the end of Day 1, you will learn the fundamental skills you need to know how to use Power BI to build the analytics process from end to end to visually explore and analyze data and build interactive dashboards that answer a variety of business problems.

    By the end of Day 2, you will learn how to do modern self-service Data Science, Machine Learning, Predictive Analytics, AI and Cognitive Services in Power BI. You will better understand the role of Citizen Data Scientist and be able to build basic machine learning predictive models without extensive background in math, statistics, machine learning, data science, Python/R programming languages.

  • In this class you will complete a data project to show off your learning experience.
  • You will be able to apply too and or have the opportunity to take advantage of data scientist citizen job titles

  • Prereqs & Preparation

  • Microsoft Power BI Desktop for Windows (free download)
  • Sign up for Power BI Web Service with a business/school email address (not free email like hotmail/yahoo/gmail).
  • For Mac users, you need to run Windows on Mac using Virtualize Windows in Parallels
  • Experience with Excel Power Query, Power Pivot & DAX is a plus, but not required

  • Coming up near you

    Let’s Keep You Updated

    Enter your email to start following

    By providing us with your email, you agree to the terms of our Privacy Policy and Terms of Service.