addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupsimageimagesinstagramlinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1outlookpersonJoin Group on CardStartprice-ribbonShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruseryahoo

Course: Power BI Essentials - AKL - Dec 2016

This course is module 1 of Power BI from Rookie to Rock Star Training

In this training course, you will learn Power BI from beginner to advance. You will learn how to use Power BI for simple data analysis situations as well as complex business intelligence scenarios. You will learn about Power BI Desktop, Power BI Website, and components of Power BI which are; Get and Transform (or Power Query), Modeling (or Power Pivot), and Visualization. You will also learn about Power Query Formula Language (Called M informally), and DAX. This course designed to give you an end to end view of Power BI, so you be able to use Power BI straight away in your everyday challenges for data analysis.

RSVP here:

https://www.eventbrite.com/e/power-bi-essentials-power-bi-from-rookie-to-rock-star-auckland-dec-2016-tickets-28931443727

1.1: Introduction to Power BI

Power BI is the newest Microsoft Business Intelligence and Data Analysis tool. In this module, we will go through basics of this product, and introduce all five components of Power BI (Power Query, Power Pivot, Power View, Power Map, and Power Q&A). You will see some demos and introduction about Power BI desktop, Office 365 Power BI subscription, and Power BI website, and mobile apps. You will see some basic demos of how easy to use is Power BI in some scenarios.

•  Introduction to Power BI: What is Power BI?

• Power BI Desktop; The First Experience

• Power BI Website; You’ll Need Just a Web Browser

• Introduction to Power BI Components: Power Query, Power Pivot, Power View, Power Map, and Power Q&A

1.2: Getting Data

Getting Data is the first experience of working with Power BI. You can connect to many data sources on-premises or on cloud. For some data sources, you can have a live or direct connection, for some connection works offline. For some connections, you need a gateway or connector to be installed. In this module, you will learn everything about get data experience of Power BI.

•  What is Power Query: Introduction to Data Mash-Up Engine of Power BI

• Get Started with Power Query: Movies Data Mash-Up

• Power BI Get Data from Excel: Everything You Need to Know

• Definitive Guide to Power BI Personal Gateway and Enterprise Gateway

• File Sources

• Folder as a Source

• Database Sources

• Analysis Services Connection

• Get Data from Azure SQL Database

• Azure SQL Data Warehouse Source

• Software as A Source

• Web Source

1.3: Power Query for Data Transformation

Data analysis and BI world starts from data extraction and transformation. Power Query is the data transformation engine of Power BI. Power Query comes as part of Excel 2016, or as an add-in for Excel 2013 and 2010. Power Query is also part of Power BI Desktop. In this module you will learn about all different version of Power Query, their similarities, and differences, as well as configuration and requirements of using them.

Power Query uses a graphical user interface to apply transformations on the dataset. However Power Query works with a functional scripting language behind the scenes. The key to learn Power Query is learning the functional language called M. There are many features in M that are not available in the Power Query GUI. In this module you will learn how to understand M, and how to write M scripts even from scratch. You will learn writing custom functions in M as well as many other useful features.

The content that you will learn in this module includes but not limited to;

•  Different versions of Power Query

• Power Query Introduction

• Query Editor

• Transformation GUI

• Row Transformations

• Column Transformations

• Data Type

• Adding Column

• Text Transformations

• Number Column Calculations

• Date and Time Calculations

• Data types, Lists, Records, and tables in M

• M built-in functions

• Generators in M

• Writing Custom Functions

• Error handling

• Advanced Data Transformations with M

1.4: Data Modelling and DAX


Power Pivot is xVelocity in-memory data modelling engine of the Power BI. Modelling effectively is the key of high performance BI solution. In this module, you will learn basics of Power Pivot such as creating relationships, and calculated members, as well as advanced best practices and DAX expressions. DAX is Data Analytical eXpression language. DAX has similar structure to excel functions, but it is different. In this module, you will learn DAX from beginner to advance. You will learn basic functions as well as complex functions and scenarios of using them in real world challenges.

The content that you will learn in this module includes but not limited to;

•  Power Pivot xVelocity engine basics and concepts

• Relationships in Power BI

• Best practices

• Introduction to DAX

• Calculated Columns

• Measures

• Calculated Tables

• Row Context vs Filter Context

• Advanced calculations using Calculate functions

• Time Intelligence Functions

• DAX Advanced

1.5: Data Visualization

Data Visualization is the front end of any BI application; this is the user view point of your system. It is critical to visualize measures, and dimensions effectively so the BI system could tell the story of the data clearly. In this module, you will learn conceptual best practices of data visualizations which is valid through all data visualization tools. You will learn Power View and Power Map skills. Power View is the interactive data visualization tool and Power Map is 3D geo-spatial data visualization tool. You will learn how to create effective charts, and dashboards using these tools as well as best practices for working with these tools. There are two version of Power View; Power View for Excel, and Power View for SharePoint which will be covered in this module as well.

The content that you will learn in this module includes but not limited to;

•  Power BI Desktop Visualization

• Custom Visuals in Power BI Desktop

• Formatting Visuals in Power BI Desktop

• Waterfall Chart

• Built-in Charts and Graphs in Power BI

• Sorting, Filtering, and categorization

• KPIs

• Maps and Geo-Spatial Visualization

1.6: Power BI Service, Dashboards, Q&A, and Gateways

Power BI introduced a new engine for users which focus on users who wants to play with the data more, and understand the story behind the data better. Power Q&A is question and answering engine which works based on human natural language. Power Q&A automatically will be enabled on Power BI files deployed into Power BI website, or Office 365 subscription. However, there are some tips and tricks about how to design your model to get the best type of answers through Power Q&A. In this module, you will learn best practices for modelling that effect on the response of Power Q&A.

The content that you will learn in this module includes but not limited to;

•  Power Q&A introduction

• Design best practices for Power Q&A

• Power BI Service

• Dashboard vs Report

• Gateways

1.7: Administration & Security

Power BI components can be deployed into different environments such as Power BI website, Office 365 subscription, or even SharePoint on-premises. In this module, we will go through deployment options, Configurations and requirements required for each environment. You will learn how to deploy your Power BI files into Power BI website. you will also learn how to build dashboards in the website, and how to work with Mobile Apps for Apple, Android and Windows Phone.

The content that you will learn in this module includes but not limited to;

•  Groups and Work Spaces

• Sharing

• Row Level Security

• Schedule Refresh



RSVP here:

https://www.eventbrite.com/e/power-bi-essentials-power-bi-from-rookie-to-rock-star-auckland-dec-2016-tickets-28931443727


Price:

early bird: $285

Standard: $365


Join or login to comment.

1 went

Our Sponsors

  • Microsoft New Zealand

    Microsoft New Zealand hosts and provides high quality venue for events.

  • RADACAD

    RADACAD sponsors our events with hosting and catering.

  • SQL PASS

    Professional Association of SQL Server

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy