21may - 22may 218:00 ammay 22Power BI from Rookie to Rock Star - Module 2: Power BI for Data Wrangler/Transformer (Data Transformation) – 2 days course - Auckland Time Zone

Register Here

Course Title: Power BI from Rookie to Rock Star

Length:

From 1 to 9 days (Lecture + Labs): depends on the modules you enrol.

Delivery method:

In-Person or Online: Check the schedule of upcoming courses.

Type of training:

Public or private (contact us for more details)

The well-known worldwide training in Power BI field, and the most comprehensive Power BI training on the planet from one to nine days of training delivered by the well-known experts and MVPs, authors of books, and speakers of many conferences themselves. 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 Components such as Power Query (Get Data and Transform), Modelling and DAX, Visualization, Power BI Desktop as the main tool, Power BI Service, Gateway configuration, and architecture. You will learn all the concepts with live demos. Expect learning best practices with great scenarios in this course. This course is designed in separate modules based on the type of audience. If you are a data analyst, data wrangler, data modeler, or data architect, or even a data scientist, this course has many things to teach you all.

This course is delivered to thousands of people all around the world, check out only a few of the recommendations at the bottom of this page, and check some of our clients.

Instructor: Reza Rad

Our trainer is the world well-known name in the Microsoft BI field. Reza Rad is Microsoft Regional Director, a speaker in world’s best and biggest Microsoft Data Platform, BI and Power BI conferences such as Microsoft Ignite, Microsoft Business Applications Summit, Microsoft Data Insight Summit, PASS Summits, PASS Rallys, SQLBits, TechEds, and so on. He is the author of books on this topic, and he has more than 15 years’ experience in the Microsoft BI technologies. Reza is the founder of RADACAD and a consultant for more than decades. He is also a Microsoft Certified Trainer for years. He is Microsoft Data Platform MVP (Most Valuable Professional) focused on BI and Data Analysis; Microsoft has awarded him MVP because of his dedication and expertise in Microsoft BI technologies from 2011 till now (more than eight years). He is the author of Power BI book from Rookie to Rock Star.

Power BI from Rookie to Rock Star

This is the most comprehensive course for Power BI on the planet which split in modules. You can enroll in any of these modules separately or take the whole course. Modules designed independently, which means each module can be taken regardless of the order of modules. Here are a list and detailed agenda of each module:

Module 1: Power BI for Data Analysts (2 days)
Module 2: Power BI for Data Wrangler and Transformer (2 days)
Module 3: Power BI for Data Modeler (2 days)
Module 4: Power BI for Architects (1 day)
Module 5: Power BI for Data Scientists (2 days)

Module 2: Power BI for Data Wrangler/Transformer (Data Transformation) – 2 days course

This training is designed for data wrangler, data developer or data transformer, who have the raw data coming from one or more data sources and want to make it ready for further modeling and analytics. In this training, you will learn detailed data transformation practices of Power BI using Power Query.

In this course, you will learn all things about Power Query, from zero to hero. You will learn Power Query from basic level with Getting data from different data sources. You will learn about different types of transformations available in Query Editor. Table transformations such as Pivot and Unpivot will be discussed, as well as specific column transformations such as date column transformations. You will also learn about M (Power Query Formula Language) in deep. Unique features such as error handling, generators, structured columns, custom functions and many other advanced level features of Power BI data transformations will be explored through hands-on labs and lecture.

After this course, you will be able to implement any types of data transformation through Power Query in Excel or Power BI. You will be able to work through your raw data and make it ready for modeling and analytics.

The training includes but not limited to topics below:

2.1: Get Data

In this section, you will learn about Power Query basics which starts with Getting data. You will learn that Power Query is the data transformation tool in Power BI. You will learn different parts of the Query Editor through an example of using Power Query to transform a dataset.

Introduction to Power Query
Query Editor
Get Data from Web
Basic Transformations
Get Data from Excel
Use First Row As Headers / Use Headers as First Row
Get Data from SQL Server

2.2: Data Types and Data Structures

Before going any further in learning Power Query, you need to understand about data structures and data types. There are three main data structures in Power Query; table, record, and list. You will learn about these types through an example of getting data from a JSON structure. You will also learn about data types and their differences.

Base data structures in Power Query
Get Data from JSON
Transforming Table, Record, and List
Data Types in Power Query
Query Operations
Enable Load; Performance Boost
Query Operations; Duplicate, and Reference

2.3: Combine Queries

One of the most common data transformations is combining datasets. Depends on the types of datasets and the way that they are related to each other, you may want to merge or append them. In this section, you will learn why you need to combine data at first, and then you will learn about scenarios that you combine data in Power Query.

Dimensional Modelling; Designing the data model
Append, creating a single big query of the same structure
Merge; Joining queries when the structure is different
Join types in Merge
Tips to consider after Merge or Append

2.4: Better Power Query Editor Experience

To get the best experience with Power Query Editor, you need to consider organizing your queries and steps in the right way. In this section, you will learn about actions you can do on steps, such as moving them up or down, splitting steps in a query, etc. You will also learn about organizing your queries in groups (folders).

Groups; Folders in Query Editor
Steps Operations
Splitting query steps
Moving steps up or down
Add as new query / Drill Down
Be Careful of Actions; Undo!

2.5: Reducing Number of Rows; Filtering

Filtering rows in Power Query is an important transformation especially when the dataset is big, or when the data needs to be cleaned. There are different ways of doing filtering in Power Query. You will learn about ways to remove some rows from the top or bottom of the table, and ways that you can filter a data table based on criteria. You will learn about basic filtering and the difference of that with the advanced filtering, and potential challenges that you may have through this process.

Row Operations; Removing rows
Row Operations; Keeping rows
Remove/Keep Errors
Remove/Keep Duplicates
Using Remove/Keep combination for troubleshooting report
Filtering based on Individual values
The dilemma of the basic filtering
Advanced Filtering
Sorting

2.6: Column Operations

A data table in Power Query can get big if you don’t care about columns. In this section, you will learn actions that you can do on columns, and what are best practices to make sure you have the best performance in your Power BI model considering columns in your tables. You will also learn about some generic column operations and transformations.

Column Operations
Choosing Columns
Removing Columns
Data Type Change
Locale consideration for the data type
Replace Values
Fill Down/Up; Very Useful for Excel

2.7: Table Transformations

Some of the most important table transformations will be explained in this section. You will learn about a way to change the granularity of a table; Grouping. You will also learn scenarios that grouping data can be more than a simple transformation. You will learn about transformations such as Transpose, Pivot and Unpivot, and the difference of all these items with scenarios of using it on real-world datasets.

Group By; Changing the granularity of the data table
Group by Advanced
Scripting and Group by; First and Last item in each group
Transpose; rows to columns and reverse
Pivot; changing the name-value structure to columns
Unpivot; changing the budget column structure to rows

2.8: Text Transformations

When you work with text values, there are many transformations you can apply. Transformations such as a split column, removing part of a text, or adding a prefix or postfix to it, concatenating some columns together, etc.

Split Column by Delimiter
Split Column by number of Characters
Split into rows instead of columns
Merge (Concatenate)
Format
The difference between Clean and Trim
Parse (XML or JSON)
Extract part of the text

2.9: Numeric Transformations

You will learn in this section how to do numeric transformations. We will talk about standard transformations such as divide and integer-divide. You will also learn about transformations such as rounding, statistics transformations, and even some scientific transformations and use cases for those items.

Standard transformations; Divide, Integer-divide, Multiply, Add etc.
Scientific transformations; logarithm, power square, etc.
Statistics transformations;
Rounding
Information functions; Is Even, Is Odd, and Sign.
Dealing with faults in Numeric calculations

2.10: Date and Time Transformations

There are many transformations applicable to date and time columns. You may want to fetch year part of a date or get the fiscal calculation of a date. You may want to calculate age based on the birthday or calculate the difference between two dates. You will learn all these items in this section, you will also learn about time zone consideration when working with current date and time in Power BI, and how you can resolve it in Power Query.

Date Transformations (Year, Month, Quarter, Week, etc.)
Extending Fiscal Date Column
Time Transformations (Hour, Minute, Second, etc.)
Adding Time/Date banding
Duration Transformation and Data Type
Age Calculation
Local Date or Time
Time zone consideration for Power BI

2.11: Structured Column Transformations

When you combine tables, you get a structured column as a result, which can be a table, list, or record in every value. There are several transformations you can apply on structured columns, which you will learn in this section. You will also learn what may be the potential issue with some of these transformations.

What is a Structured Column?
Expand
Aggregate
Expand and Aggregate: Performance Consideration

2.12: Add Column Transformations

There are two types of transformations in Power Query; Transforming an existing column, or adding a column based on a transformation. In this section, you will learn about these two types, their differences, and few other transformations that we have available in the add column tab of the Power Query Editor through some examples.

Add Column vs. Transform?
Add Column with a Transformation
Index Column: Row Number
Conditional Column
Add Column by Example; When you don’t know which transformation to use
Add Custom Column: Generic

2.13: Functions and Parameters; Dynamic Power Query

Power Query is a powerful tool for data transformation. This power can be amplified even more if you can make your queries dynamic. Instead of repeating several steps for similar data sources, you can create a function from those steps, and run that function for all other sources. Functions get parameters as the input. Functions and parameters can make everything in Power Query dynamic. If you want to learn Power Query advanced deep dive, this is the section to go through.

Defining Parameters
Using Parameters in an existing query
Advanced GUI for parameters
Creating Function from a query
Invoking the sample function
Add Column Transform: Invoke Custom Function
When the advanced GUI does not exist

2.14: Power Query Formula Language: M

The heart of Power Query is a scripting language named Power Query Formula Language or M. If you want to be a good data wrangler or data developer with Power Query, you must learn M scripting. The good news is that M scripting is not a hard language to learn. This section goes through the basics of the language, data types, literals, and everything is needed for understanding an M script’s structure.

What is M? and the importance of learning M
M Syntax
End of the line
Variable Names
Special Characters
Escape Character
Step by Step Coding
Literals
Function Call
Comments
A real-world example

2.15: Working with Data Structures in M

As you are dealing with data in Power Query, it is important to learn how to work with table, list, and record from the code. In this section, you will learn about these three structures in code, and how to navigate between different parts of each structure.

Primitive Value
List
Record
Table
Function
Navigating through List and List functions
Navigating through Record and Record functions
Navigating through Table and table functions
Concatenating lists and records

2.16: Advanced M Scripting

Now that you know more about M scripting, it is time to see how powerful this part of Power Query can be compared to the graphical interface of query editor. In this section, you will learn features that you have access to apply using M scripting. You will learn ways to get a list of all functions, doing error handling in an advanced way. Applying some changes in functions and parameters which is only possible through the code. You will also learn an end-to-end example using everything you learn about M at the end.

#Shared Keyword; function library of Power Query
Parameters in the code
Custom Functions through scripting
Error Handling in Power Query
Generators in Power Query: Implementing Loop Structure
EACH: singleton function
Sample Custom Function: Day Number of Year Custom Function

2.17: Performance Tips and Tricks for Power Query

Some transformations or operations needs careful attention in Power Query. In this section, you will learn about performance tips and trick for Power Query to make sure you have always a well performance tuned data transformation logic. Each sample will be discussed through the live demo in this section.

Enable Load; Simple, but Efficient
Reducing Number of Columns
Query Folding
Grouping and Aggregation; Performance Consideration
Merge; Before and After, things to Consider

2.18: Error Handling

In any data related solution, you should expect bad data rows to appear. If you haven’t thought about the appearance of bad data rows and you just did the transformations considering everything will be nice and tidy, then you may face many errors in Power Query. This section is all about how to handle errors, deal with bad data rows, create troubleshooting reports, etc.

Keep/Remove Errors; Troubleshooting report
Count Rows
Reference/Duplicate
Replace Errors
Data Type considerations

2.19: Use Cases

At the end of the training, we go through some end-to-end solutions using Power Query. These solutions leverage everything you learned through the training about this tool and language; you will see how all those parts come to help together to build the solution. We will go through building a date dimension which has all calendar columns, fiscal columns, and public holidays fetched live, and we will talk about combining files from a folder.

Date Dimension with Power Query; building the base table
Adding Fiscal columns to the Date dimension
Getting public holidays live and merging to the date dimension
Looping through files in a folder with Power Query

Register Here

Why Power BI Training?

Power BI is the newest Microsoft BI tool for data mash up, build modeling, and visualize it effectively. It supports mobile devices, it supports self-service, and along with its great functionalities, it doesn’t require heavy development or production system.

Common Myths about Power BI

There are some myths about Power BI that sometimes prevents people and organization to move towards using this product. We’ve listed some of the myths in following. Please note that these are Myths, and they are not the right assumptions.

Myth 1: Power BI is a self-service Excel tool, and isn’t suitable for Enterprise Solutions.

There are many scenarios that Power BI has been used in enterprise solutions. Power BI features for data mash up (with the very powerful data transformation component: Power Query), and data modelling based on xVelocity in-memory engine (Power Pivot), and great data visualization components such as Power View and Power Map, along with mobility support of this product, are rarely available in other products. We have designed, implemented and have seemed many BI enterprise solutions based on Power BI within very large organizations.

Myth 2: Power BI is easy to use, and doesn’t require a training course.

Power BI is an easy to use tool, but for basic functions. Every BI application requires calculated measure, which needs to be written in DAX. Every BI application requires advanced data transformations which need to be handled with Power Query M scripting language. Designing and implementing solutions with Best Practices is always a requirement for reliable BI applications. We designed our Power BI training in a way that delivers advanced content for all components of Power BI, and fortify your team’s knowledge on the product, so they can solve any complex challenge with this tool.

Myth 3: Power BI is only for Microsoft based environments and platforms.

Power Query is the core of data extraction in Power BI. Power Query supports a wide range of data sources. Not only SQL Server, but also Oracle, MySQL, web service result set, DB2 and many other data source are supported. There is also the possibility to connect to many systems such as Salesforce. The Visualization component of Power BI is also HTML5 supported and is available for all mobile devices. Power BI app in AppStore, and Google PlayStore, as well as Microsoft AppStore, enables dashboards and data visualizations to be available in all environments.

Myth 4: Power BI is not a powerful and fully functional BI tool, and cannot be compared with other tools in the market.

In fact, the reverse is true. Power BI is such powerful that can be the replacement of many other expensive BI tools in the market. We’ve been through scenarios of successful Power BI solutions that have been a replacement of Cognos, IBM products, Oracle WB, SAP BO, and so on. Power BI has 5 powerful components that cover main aspects of BI and data analysis system.

In addition, there is always the possibility to use this as a hybrid approach and save lots of time and money along with great features that are only available in this product.

In-Person Training;

Our Power BI in-person training will be held in high-quality venues with the recommendation for hotel bookings for attendees. There will be special group rating fee as well as early bird and past attendees discount. for the schedule of our in-person training follow this link:

https://radacad.com/events

Online Training;

We run online training with GoToWebinar and GoToTraining applications. These applications provide a highly reliable communication channel between instructor and attendees. For the schedule of our online training follow this link:

https://radacad.com/events

Use the letter written for your boss to convince him/her to pay for your Power BI Training course

Check Schedule of upcoming events here

Check cancellation policies and rates here

What others say about the training and trainer

Daniel R Tuma, Senior Systems Analyst at Cleveland Metro Schools, Ohio, USA

I spent probably about two weeks looking for a good Microsoft Power BI class that would cover all of the aspects of the program. I wanted to walk away from the class being able to apply what I learned immediately. Most training companies that I looked into were in a state of flux with Power BI mostly due to the transitions that Power BI itself was going through. Then I stumbled on the RADACAD web site. Reza Rad touted a course that he taught named “Power BI, From Rookie to Rock star.” If the class was indeed an A to Z course, then it was exactly what I was looking for. The class outline seemed to include every topic on my checkoff list plus much more. I decided to give Reza a try.
Reza completely lived up to his hype. He took us through a natural progression of the software, using example after example of how to complete a task. We went through real world scenarios, a bare minimum of two scenarios for each minor topic. I was completely impressed with his Power BI knowledge, understanding and abilities. Any question we came to Reza with was answered completely and with even more examples.
After the class, my goal of immediately applying what I learned was attained. Right away I was able to successfully pull and massage data, create useful reports and post them to dashboards.
I would recommend Radacad Power BI Training without hesitation.

Jeffrey Weir; Independent Consultant, Wellington, New Zealand

I learned a lot from this course: it gave a great overview of what’s possible both right from the UI, and what more awaits if you lift the hood and pimp the engine. It’s incredible to see just how much PowerBI and PowerQuery radically simplify what I would otherwise have to do with many, many lines of complicated VBA code. And Reza is a masterful user of this tool.

Note that Reza covers a lot of ground in this course, and it is pretty fast paced. While you can take a laptop and follow along as Reza takes PowerBI/Powerquery through its paces, for the one-day course my recommendation would be to keep that laptop closed, and simply sit back and watch Reza in action, so you can fully concentrate on just how simple this tool is to use in the right hands as well as think about how you might use the tool to your own ends and ask questions along those lines. You can always purchase the video course (if it’s not already included in your course) and step through the material again at your own pace.

Rob Wilby; Independent Consultant, UK

I must say your “Power BI Essentials” course has been the most comprehensive Power BI course I have found to date and seeing how you work with data especially the little tricks naturally introduced at just the right moments has made this course a pleasure to take.

Martin Catherall – Data Platform MVP, PASS Regional Mentor

I attended Reza’s Power BI pre-con “From Rookie to Rock star” at SQL Saturday Brisbane in May 2016. I was a complete Power BI novice, having only previously accomplished a few very basic things with Power BI. Reza took the group through all the components that make up environment. He explained how they had evolved and took the group through walk-throughs of each one. Reza was great an answering questions from the audience at the event and going into extra detail if necessary. All-in all, I would say that I’m now a very confident Power BI user after attending Reza’s pre-con.

Dan Cheshire, Senior Project Manager Air New Zealand

Reza does not just know Power BI like the back of his hand, he is the most commercially aware BI person I know. He understands that companies work in the real world and that data isn’t always clean and needs manipulation for it to work and be useful. When Reza worked on our project, nothing phased or flustered him, he always came up with solutions for problems that seemed to me as insurmountable. Can’t recommend him enough, invest in Reza as he will not only save you a whole heap of time, but he comes up with long lasting and very powerful Power BI solutions for your business.

Sonia Buckley, Data Analyst at Zoom2u, Sydney, Australia

We have started to use Microsoft Power BI and whilst Microsoft tutorials are helpful, if you are not used to DAX then it is very difficult to get your head around and there is little other resources that don’t cost an arm and a leg. I had a call with Reza who made my life so much easier in just under an hour! Any time spent speaking to Reza will be well worth it – I have saved hours of trying to get my head around our dashboards by getting some very useful tips and explanations on why things are done the DAX way! Not only that but he is very patient and straight forward. Highly recommended!

R. Kemp, Canada

The course was an excellent investment overall, it exceed my expectations. It was well paced and presented. The instructor, Reza Rad, was excellent and was able to answer all my questions and explain complex idea in a manner that was easy to understand and follow. I had been using Power BI Desktop for a number of months prior to taking this course, but wish I had attended it sooner! The course structure of 1 day of overall Power BI and followed by 4 days of more intensive instruction on the various parts of Power BI allowed for a basic understanding of the whole, and then more comprehensive learning. The live-on-line experience worked well technically and allowed for questions and problem-solving with the instructor. I learned a lot about Power BI and this course gave me a great foundation for using Power BI to clean, model, design, and share reports using a variety of visualizations that will provide business intelligence to my company. I would recommend this course to anyone wanting to learn Power BI either as a starting point or even after you have used the tool to deepen your understanding and build your skill-set.

Who Attended RADACAD Training Courses

Register Here

Cancellation:
Cancellation up to 5 weeks before the event: full refund minus administration fee ($50) and credit-card processing fees (if applicable).

Cancellation from 5 weeks to 2 weeks before the event: 50% cancellation charge, 50% refund

Cancellation from 2 weeks before the event: 100% cancellation charge, 0% refunded.
Transfer:
Transfer fee to another event date* (up to 2 weeks before the event): 25% of the standard price of the event to transfer

Transfer fee to another event date* (from 2 weeks to 1 day before the event): 40% of the standard price of the event to transfer

Transfer fee at the day of event*: 60% of the standard price of the event to transfer

*transfer can be done only once, and it can be only transferred to another date not later than 6 months from the original event.
No Show:
No fee will be refunded for no show.

Save

Time

21 (Tuesday) 8:00 am - 22 (Wednesday) 4:00 pm GMT

Location

Auckland TBD

Organizer

Reza Radreza@radacad.com

Learn More

21may - 22may 218:00 ammay 22Data Science Training - Module 2: Data Science with Microsoft Cloud – 2 Days Auckland Time Zone

Register Here

Course Title: Data Science and Advanced Analytics with Microsoft Technologies

Length:

From 1 to 7 days (Lecture + Labs): depends on the modules you enroll.

Delivery method:

In-Person or Online: Check the schedule of upcoming courses.

Type of training:

Public or private (contact us for more details)

The well-known worldwide training in Microsoft Advanced Analytics field on the planet from one to seven days of training delivered by the well-known experts and MVPs, authors of books, and speakers of many conferences themselves. In this training course, you will learn some basic concepts for Machine Learning, Predictive and Descriptive analytics. You learn how to write R codes for the aim of data wrangling, data modeling, data visualization, and machine learning. Moreover, you will learn how to use custom AI tools like Azure Machine learning for creating your desire model, deploy it and use it as web service in other applications and scenarios like the Internet of Things (IoT). You will learn about how to use R in a dashboard, how to R in the cloud and on-premises storage. You will learn how to use pre-build AI tools like Bot and cognitive services to create smart report and applications. Expect learning best practices with great scenarios in this course. This course is designed in separate modules based on the type of audience. If you are a data scientist, data analyst, business intelligence developer, or data architect, this course has many things to teach you all.

This course is delivered to thousands of people all around the world, check out only a few of the recommendations at the bottom of this page, and check some of our clients.

Instructor: Dr. Leila Etaati

Our trainer is the world well-known name in the Microsoft Data Science field. Leila Etaati is Microsoft AI, and Data Platform (Most Valuable Professional) focused on AI and BI Microsoft technologies; Microsoft has awarded her MVP because of her dedication and expertise in Microsoft BI technologies from 2016 till now, she is one of two AI MVP in Australia and New Zealand. She is a speaker in world’s best and biggest Microsoft Data Platform, BI and Power BI, AI conferences such as Microsoft Ignite, Microsoft Business Applications Summit, Microsoft Data Insight Summit, PASS Summits, PASS Rallys, SQLBits, TechEds, and so on. She is the author of some books on this topic, and she has more than 11 years’ experience in the Microsoft BI technologies and Data science. Leila is the co-founder of RADACAD and a consultant for more than seven years.

Advanced Analytics with Microsoft Technologies

This is the most comprehensive course for Microsoft Advanced Analytics and Data Science on the planet which split into modules. You can enroll in any of these modules separately or take the whole course. Modules designed independently, which means each module can be taken regardless of the order of modules. Here are a list and detailed agenda of each module:

Module 1: Power BI for Data Scientists (2 days)
Module 2: Data Science with Microsoft Cloud (2-days)
Module 3: Advanced Data Science with Microsoft Services (2-days)
Module 4: AI and Cognitive Services in Applications (1-day)

Module 2: Data Science with Microsoft Cloud – 2 days course

This training is designed for data scientists, data developer or data architecture, who have the data in the cloud or thinking about using Microsoft machine learning tools in cloud scale. In this training, you will get familiar with machine learning cloud possibilities.

In this course, you will learn how to Azure ML Studio as the first tool for machine learning cloud that introduced in 2014. The detail on how to create a model, how to enhance machine learning algorithms, how to import data and so forth will be explained. Then, you will get familiar with Azure Data Science Virtual Machine as a comprehensive tool for machine learning, some of the tools in it like the Tensor flow and Azure ML workbench will be explained. Then, how to do machine learning in Azure Data Lake store will be explained. Finally, Azure Data Bricks and how to use it for the aim of machine learning will be explained too. This training has many hands-on labs, and all the required scenario will be explained step by step.

At the end of this training, the audience will learn how to define a machine learning problem and how to use Azure ML Studio for cloud machine learning, and also how to use Azure data Lake Analytics, Azure Data Bricks and so forth for machine learning.

The training includes but not limited to topics below:

2.1: Azure Machine Learning (ML) Studio

In this section, you will learn some basic of machine learning and how it works. Then some introduction to Azure ML Studio will be provided.

Import data: The main component for importing data from local PC, how to import data from another workspace, how to import data from HTML website, how to import data from cloud such as Azure SQL DB.
Data Cleaning: data cleaning is the main process that we should do before any machine learning process. I will explain the available component in Azure ML. How to clean missing values, remove duplicate data, select column, clip value (remove outliers), group data into bins, and create an indicator for data. You will learn how to normalize the data, how to use SQL Statement for data transformation, how to use enter data manually, how to edit the data type, change the column name with edit metadata component, how to join data from different data resource , how to increase the number of low incidence in a dataset which unbalanced.
Feature Selection Data Sampling: the process of feature selection will be explained, how to split data, how to partition data using a sampling approach, how to create different folds for the aim of cross-validation.
Models: a bit talk about the available models in Azure mL for predictive, descriptive, prescriptive and anomaly detection. An example of a prediction of a group, a value, clustering data and anomaly detection will be shown. For each scenario, an example will be presented; different algorithms will apply to a problem. The main concepts of k-mean, how to use elbow chart to identify the number of the cluster will be discussed, the PCA chart will be explained. The trained model for recommendation “match box recommender” will be explained through a scenario. The main concepts of collaborative filtering and content-based filtering and hybrid approach for recommendation will be discussed.
Training and Scoring models: how to choose algorithms and how to train model and test model, what is cross-validation, how to do cross-validation to apply a model to different folds of data, how to check the different values for each parameter and see the related accuracy to that.
Evaluate: how to evaluate a classification problem concepts of Accuracy, Recall, Precision, AUC will be discussed, the evaluation criteria for regression algorithm MAE, RMSE and so on will be shown. How to evaluate and see the result of more than three algorithms on one dataset will be shown. Using different evaluate the model, enter data manually component and add row component.
Publish to Web: the process of creating a web service from a model will be discussed, how to check it in Excel will be shown, also how to use it in Stream Analytics as a function for data will be shown.
Sharing workspace, create projects: the process of how to share the workspace with others will be discussed, how to create a project for each experiment, how to create a trained model component for reuse, and a data transformed dataset, how to export datasets to CSV, and other formats will be shown.
Azure ML model in Power BI: Create a model in Azure ML Studio and use it in Power BI
Azure ML Model in IoT: the process of how to create a model in Azure ML model studio and apply it on streamed data.

2.2: Data science Virtual Machine

The Data Science Virtual Machine (DSVM) is a customized VM image on Microsoft’s Azure cloud built specifically for doing data science. It has much popular data science and other tools pre-installed and pre-configured to jump-start building intelligent applications for advanced analytics. It is available on Windows Server and Linux. In this session, the audience will learn

How to set it up
- Environment needs
- What parameter needs to be set up
What software and tools can be used
- visual studio and how to access R and Python
- Azure ML workbench
- SQL Server and Power BI
Deep learning introduction
Deep learning tools such as Tensor flow and so forth.
- Tensorflow
- Weka

2.3: Azure Data Lake Analytics

Azure Data Lake Analytics is a distributed, cloud-based data processing architecture offered by Microsoft in the Azure cloud. It is an on-demand analytics job service that simplifies big data. Instead of deploying, configuring, and tuning hardware, you write queries to transform your data and extract valuable insights. The analytics service can handle jobs of any scale instantly by setting the dial for how much power you need. You only pay for your job when it is running, making it cost-effective. In this section, you will learn

How to set up Azure Data Lake Store gen1 and Azure Data Lake Analytics
- Th main process of how to set them up will be explained
- How to access Azure Data Lake Analytics via visual studio also will be explained
How to use an existing sample of U-SQL
- An introduction into USQL
- How to run USQL in the cloud and how to run it
How to write R codes inside USQL
- How embed the R or Python code
- How to pass parameters and access the data
What is the best practice to create a machine learning project in data Lake
- How to create a model
- Store model
- And use the model for production

2.4: Azure Data Bricks

Azure Databricks is an Apache Spark-based analytics platform optimized for the Microsoft Azure cloud services platform. Designed with the founders of Apache Spark, Databricks is integrated with Azure to provide one-click setup, streamlined workflows, and an interactive workspace that enables collaboration between data scientists, data engineers, and business analysts. Azure data bricks are one of the main platforms for the aim machine learning in this part audience will get familiar with

What is data bricks and how to set it up
The environment of data bricks and explain how they work
How to able to write R, Python, Scala, and SQL at the same time
Visualization of Databricks
Workspace and clusters
How to get information from Azure Data Lake store
How to get data from event Hub
What is notebook
How to pass data from one cell to other
How to use Databricks for a machine learning scenario storage model in Azure Data lake and show the result in Power BI

In-Person Training;

https://radacad.com/events

Online Training;

https://radacad.com/events

Use the letter written for your boss to convince him/her to pay for your Power BI Training course

Check Schedule of upcoming events here

Check cancellation policies and rates here

What others say about the training and trainer

Kenny McMillan, Sports Physiologist / Data Analyst, Frankfurt, Germany:
I attended RADACADs “Advanced Analytics” course recently in Frankfurt in May 2017. Being a regular user of Power BI (with a science background ) the course was extremely helpful in showing me how to incorporate R data visualizations into Power BI dashboards and for introducing me to machine learning using the Microsoft ML Studio. Leila is an excellent and extremely knowledgeable instructor and explained complex data analytical concepts and methodologies in an easy-to-understand manner. I thoroughly recommend this course to anyone who wants to expand their data analytical skills and knowledge.

Martin Catherall (Microsoft Data Platform MVP):

As part of SQL Saturday Auckland 2016 I attended an “Analytics with Power BI and R.” pre-con with Leila. Leila took the class’s knowledge from rudimentary to competent in a day. We first looked at R, the language and the software. Once these skills were obtained we started to look at Power BI and the integration that it has with R. We worked through a few examples and Leila answered all of the class’s questions and offered to provide supplementary material for some of the more advanced questions. I left the class feeling that my R and Power BI knowledge was at a competent level and ready to dive into some of the more advanced material that Leila provided.

Who Attended RADACAD Training Courses

Cancellation:
Cancellation up to 5 weeks before the event: full refund minus administration fee ($50) and credit-card processing fees (if applicable).

Cancellation from 5 weeks to 2 weeks before the event: 50% cancellation charge, 50% refund

Transfer fee to another event date* (from 2 weeks to 1 day before the event): 40% of the standard price of the event to transfer

Transfer fee at the day of event*: 60% of the standard price of the event to transfer

*transfer can be done only once, and it can be only transferred to another date not later than 6 months from the original event.
No Show:
No fee will be refunded for no show.

Save

Time

21 (Tuesday) 8:00 am - 22 (Wednesday) 4:00 pm GMT

Location

Auckland TBD

Auckland, Auckland, New Zealand

Organizer

Leila Etaatileila@radacad.com

Learn More

7jun9:00 am- 5:00 pmDefinitive Power BI Architecture, Davie, Florida

Re gister Here

Description

Enjoy a full day pre conference with Reza Rad
(https://radacad.com/)

Definitive Power BI Architecture

This training is designed for data architect or administrator, who is designing the architecture of leveraging Power BI in a solution. Someone who wants to understand how all components of Power BI are sitting beside each other to build the whole solution. This training is designed for understanding the strategy of using Power BI rather than the development of it.

In this training, you will learn about architecting the strategy of a Power BI solution from end to end. This is not training about development. However, knowing some of the basics of Power BI is helpful.
You will learn about Power BI Service, and different types of connections in Power BI and choose the right type of connection for your solution. You will also learn all different ways of sharing a Power BI Solution and the pros and cons of each. The course continues with a detailed discussion about row-level security. You will learn how gateway configuration and set up will be in the whole package. You will also learn about integrating Power BI with other tools, and some architecture blueprints to follow when you are designing a Power BI solution.

At the end of this training, you will be able to design the architecture of Power BI for your requirement; you can choose the right way of sharing and design the gateway configuration as well as the communication of Power BI with other tools and services. You will be able to answer any questions that come to your mind about a solution architecture in Power BI world and make the right decision to choose the right strategy of Power BI usage in your organization.

The training includes but not limited to topics below:

1: Power BI Service
Power BI service or website plays an important role in designing a Power BI solution. Power BI website is the hosting environment for Power BI reports, dashboards and datasets. In this section, you will learn about these objects and their configuration. You will also learn about the different types of connections in Power BI, and the position of the gateway in the solution, configuring and installing it.
• Power BI Components
• Power BI Service Content; Dashboard, Report, and Dataset
• Dashboard Features in the service
• What is Gateway?
• Two types of Gateway; On-premises, Personal
• Configuration and Installation of Gateway
• Import Data and Schedule Refresh
• DirectQuery Connection
• Live Connection
• Composite Model

2: Sharing
There are several ways of sharing Power BI reports and dashboards. Each of the methods has pros and cons and should be used in specific scenarios. In this section, you will learn scenarios to use each of these methods for sharing, and the sharing of architecture, and a comparison between all these methods at the end.
• Basic Dashboard or Report Sharing
• Workspaces in Power BI; Dev Environment
• Power BI Apps; User Environment
• Publish to Web
• Embed in SharePoint Online; Office 365 Integrated Sharing
• Power BI Embedded; Embedding content into another application
• Comparison of all Sharing methods

3: Security
Sharing is about giving users access to the entire content; security is about giving them access to part of it. There are different ways of implementing security (which is called row-level security in Power BI). Statics row-level security is a good option when roles are limited items. The next level is to define a dynamic row-level security using DAX functions. Dynamic row-level security comes as different patterns which will be discussed here through examples.
• Row Level Security
• Dynamic Row Level Security
• Patterns for Dynamic Row Level Security
• Manager Level Access
• Organization Chart Access as Dynamic Row Level Security
• Profiles and Users; Dynamic Row Level Security
• Dynamic Row Level Security using SQL Server Analysis Service Live Connection

4: Administration and Licensing
As a Power BI administrator, you need to have a careful eye on some of the metrics, and control some of the settings across your organization Power BI tenant. In this section, you will learn about Power BI administrator configuration options and options which are critical to controlling. You will also learn about all licensing options for Power BI and will have a clear view of what would be the best licensing option for you.
• Power BI Administrator Configuration
• Usage Metrics
• Customizing Usage Metrics
• Power BI Licensing Guide
• Power BI Premium
• Power BI Embedded Licensing

5: Integration
Power BI can integrate with other tools and services such as Reporting Services and Excel. In this section, you will learn about all integration options for Power BI. This section will also give you a full understanding of Power BI Report Server; the on-premises usage of Power BI. You will learn Power BI REST API capabilities (not at a developer level, more in architecture level), and you will learn about real-time streaming options available with Power BI.
• PowerPoint Integration with Power BI
• Power BI and Excel; More than just an Integration
• Power BI Report Server: Power BI on-premises
• SQL Server Reporting Services Integration with Power BI
• Real-time Streaming with Power BI, and Azure Stream Analytics
• Power BI REST API

6: Architecture
The last part of the training focuses on architecture blueprints for Power BI. In addition to architecture best practices for sharing, self-service, enterprise-level architecture, you will learn about a tool that can help in Power BI solution designed by RADACAD; Power BI Helper.
• Architecture for Enterprise Scale
• Architecture for Sharing
• Architecture for Self-Service
• A tool that helps: Power BI Helper

*Lunch will be provided.

Early Bird Ticket (before April 2, 2019): $149.00

Premier Discounted Ticket (before May 1, 2019): $189.00

Regular Price Ticket (from May 1, 2019): $225.00

FAQs
What are my transportation/parking options for getting to and from the event?
Event Location: https://goo.gl/maps/NnHrzk1AddH2
Parking lots: Is the building structure adjacent to the Carl DeSantis building.

What can I bring into the event?
Laptop, pen and writing pads

For any questions and/or special accommodations or dietary requirements. Please email us!
SQLSaturday864@sqlsaturday.com

What’s the refund policy?
10% fee applies if cancelled on or before May 15, 2019.
No refunds after May 15, 2019

Time

(Friday) 9:00 am - 5:00 pm EDT

Location

Nova Southeastern University 3301 College Avenue Carl DeSantis Building Davie, FL 33314 United States

Organizer

Reza Radreza@radacad.com

Learn More

18jun - 19jun 188:00 am- 4:00 pmPower BI from Rookie to Rock Star - Module 3: Power BI for Data Modeler (Data Modelling and DAX) – 2 days course Auckland Time Zone

Register Here

Course Title: Power BI from Rookie to Rock Star

Length:

From 1 to 9 days (Lecture + Labs): depends on the modules you enrol.

Delivery method:

In-Person or Online: Check the schedule of upcoming courses.

Type of training:

Public or private (contact us for more details)

The course is scheduled for Auckland’s time zone from 8:00 Am to 4:00 PM each day.

You can join this course online if you are in other countries and cities. We use the reliable channel of GoToMeeting (which is like Skype) for the course. You will be online at the same time as other students and instructor. We will have full-screen sharing, video and audio experience through GoToMeeting. You would be able to ask any questions you have and get responses directly from the instructor, and even share your screen to ask a question from the instructor in case needed.

This course is delivered to thousands of people all around the world, check out only a few of the recommendations at the bottom of this page, and check some of our clients.

Instructor: Reza Rad

Power BI from Rookie to Rock Star

Module 1: Power BI for Data Analysts (2 days)
Module 2: Power BI for Data Wrangler and Transformer (2 days)
Module 3: Power BI for Data Modeler (2 days)
Module 4: Power BI for Architects (1 day)
Module 5: Power BI for Data Scientists (2 days)

Module 3: Power BI for Data Modeler (Data Modelling and DAX) – 2 days course

This training is designed for data modeler, who have the data prepared to be modeled for analysis. Usually, people who attend this training needs to attend module 2 beforehand to learn about the step before the modeling. In this training, you will learn detailed modeling practices of Power BI, and DAX unleashed.

In this two days training, you will learn DAX from zero to hero. You will learn how to design the best model in Power BI with relationships, considering formatting and data types. You will learn about DAX which is the data modeling expression language in Power BI (and SSAS Tabular, and Power Pivot). You will learn from Simple DAX calculations to complex expressions and calculations for solving real-world challenges of a BI solution.

The training continues with more focus on DAX; we will talk about the evaluation context in DAX, which defines the mindset and the way of thinking when you are writing DAX expressions. You will learn about DAX function categories such as Aggregation functions, Iterators, Filter functions, parent-child functions, time intelligence functions, functions dealing with relationships, etc. You will learn all scenarios through hands-on examples of real-world data.

At the end of this training, you will be able to design the proper data model in Power BI, understand all relationship requirements and implement the right relationship, write complex DAX expressions for your analytics need, and put them all together to build the best model for your data analysis solution using Power BI.

The training includes but not limited to topics below:

3.1: Power BI Modelling 101

Power BI Modelling engine is based on the same engine used in Excel Power Pivot, and SQL Server Analysis Services Tabular. Power BI uses the in-memory engine, named xVelocity. The in-memory engine of Power BI makes the analysis super-fast. Everything will respond very fast in this model. In this section, you will learn about the basics of the modeling engine and some of the differences of that with SSAS and Power Pivot.

Basics of Modelling in Power BI
The step before this: Data Preparation
Relationships in Power BI; Filter propagation
Direction of Relationship
Be Careful of both directional relationship
Active or In-active relationships
Relationship based on multiple Columns
Role Playing Dimension
Formatting
Hide/Unhide Columns
Hierarchy Definition in Power BI
Sort by Column

3.2: Introduction to DAX

DAX is an abbreviated name for Data Analysis eXpression language. This is the expression language in Power BI for analytics. DAX is a dynamic expression language which will consider the interaction of the user at the time of visualization. Using DAX, you can do calculations such as year to date, year over year comparison, etc. Most of the data modeling training is about DAX. In this section, you will learn the basics of DAX.

Syntax of DAX
Naming in DAX
Operators and Operands
Logical Operations
Data Types in Power BI Model
Overview of Functions in DAX
Variables
DAX or M? When to use Which?

3.3: Calculations in Power BI

There are three types of calculations in Power BI. Calculated Column, Measure, and Calculated Table. You can write DAX expression in all these three types of objects. This section will teach you what the main difference between the calculated column, measure, and the calculated table is, and what are scenarios of using them.

Calculated Column; Row by Row
Measure; Single Output
Calculated Table; A derived table
Calculated Column? Maybe a good candidate for Power Query transformation
Measures are Dynamic

3.4: Aggregation and Iterator Functions

The first set of important functions in DAX are aggregation functions. There is a set of normal aggregation functions such as SUM, MIN, MAX, and there is another set called iterators. The way of working with iterators is different. Iterators get an input table and an expression. Example of iterator function is SUMX. In this section, you will learn the difference between SUM and SUMX and scenarios of using those two.

Aggregation Functions
Implicit Measures vs. Explicit Measures
Sum of an Expression: SumX
Iterator Functions
Difference between SUM and SUMX

3.5: Filter Functions

Filter functions are probably the most important functions in DAX. You can refer to a column in DAX (like Excel), but you cannot refer to rows. If you want to refer to rows in an expression, you must filter it, and that is why Filter functions are important. There are several filter functions, and the behavior of all of them are unique. In this section, we will talk about some of these functions through real-world examples.

ALL
Filter Functions to be used inside other functions
Examples of using ALL function
ALL and SUMX; Percentage Calculation
AllExcept
Filter Function: Custom Filter
Values/Distinct; getting a unique list of values

3.6: Evaluation Contexts and Conditional Sum

Understanding Evaluation contexts are one of the most critical learnings in DAX. The evaluation context refers to the way that filters impact the calculation’s result in DAX. There are two types of contexts; Row context, and filter context. In this section, you will learn about the difference of all these, and you will learn scenarios that you need to be careful when the context changes.

Row Context
Filter Context
Exception for Row Context
Exception for Filter Context
Calculate Function
Conditional Sum; Three ways of Implementing; pros and Cons
Variables in DAX and using them for debugging

3.7: Relationship Functions

Some of the functions in DAX are going through directions of relationship and apply some filtering based on that, like RELATED() for example. Some other functions change the behavior of relationship such as UseRelationship() function. In this section, you will learn about relationship functions in DAX and scenarios of using them.

Related: Many to one
RelatedTable: Sub table that can be used as a filter
CrossFilter: Changing Direction of relationship
UseRelationship: using an inactive relationship
TreatAS function

3.8: Time Intelligence Functions

Calculations based on time and date are critical for many businesses such as finance. You can use DAX to do calculations such as year to date, fiscal year to date, year over year comparison, and rolling 12 months average. In this section, you will learn some basic time intelligence functions such as TotalYTD to a calculated year to date. You will also learn about scenarios when you do not have the built-in function for your use case and will learn how to write the combination of function usages in DAX to achieve the solution.

Choosing the Date Table: Built-in or Customized Date Table
Mark as Date Table
Year to Date, Quarter to Date
Fiscal Year to Date
Same Period Last Year
Year over Year Comparison
ParallelPeriod vs SamePeriodLastYear vs DateAdd
Running Total
Rolling 12 Month Sales
Average 12 Month Sales
Rolling 6 Months
Flexible time banding
Time zone consideration in Power BI

3.9: Dynamic DAX: Parameters

DAX calculation is dynamic based on the user interaction in a Power BI report page. However, you can take a step further, and make the expression of DAX even more dynamic. The user can change a value which is defined statically in your DAX expression using a parameter. Parameters will make your DAX expressions even more dynamic. In this section, you will learn about parameters, and their usages, and the scenario of using a parameter table to select from multiple measures dynamically.

Numeric Parameter Definition through GUI
GenerateSeries DAX function
SelectedValue DAX function
Sample Scenario: Customer Retention with Dax and Power BI
Other Types of Parameters? Parameter Table
SWITCH
Sample Scenario: Selection of Measures in a table dynamically

3.10: Parent-Child Functions

DAX can navigate through a hierarchy with an unknown number of levels. Example of such a hierarchy is a chart of accounts or organizational hierarchy. In this section, you will learn about parent-child functions which can be used for organization hierarchy. You will learn different scenarios of using these functions in real-world examples.

Organizational Hierarchy or Chart of Accounts: unknown levels
Path function
PathLength: getting the number of levels
PathItem: finding a specific level
PathItemReverse
PathContains: Security Pattern
LookupValue: To get the other related fields

3.11: Best Practices Tips and Tricks

Performance considerations when doing the modeling in Power BI is the last but not least important part of this course. You will learn about tips and tricks that keep your model performing well even with a huge number of data rows. In this section, you will also learn about other tips that make the maintenance of your model easier, such as using a tool like Power BI Helper.

Modelling Best Practices
Understanding when to switch between Power Query and DAX
Considerations for very large tables
A tool that helps: Power BI Helper

Register Here

Why Power BI Training?

Common Myths about Power BI

Myth 1: Power BI is a self-service Excel tool, and isn’t suitable for Enterprise Solutions.

Myth 2: Power BI is easy to use, and doesn’t require a training course.

Myth 3: Power BI is only for Microsoft based environments and platforms.

Myth 4: Power BI is not a powerful and fully functional BI tool, and cannot be compared with other tools in the market.

In addition, there is always the possibility to use this as a hybrid approach and save lots of time and money along with great features that are only available in this product.

In-Person Training;

https://radacad.com/events

Online Training;

https://radacad.com/events

Use the letter written for your boss to convince him/her to pay for your Power BI Training course

Check Schedule of upcoming events here

Check cancellation policies and rates here

What others say about the training and trainer

Daniel R Tuma, Senior Systems Analyst at Cleveland Metro Schools, Ohio, USA

I spent probably about two weeks looking for a good Microsoft Power BI class that would cover all of the aspects of the program. I wanted to walk away from the class being able to apply what I learned immediately. Most training companies that I looked into were in a state of flux with Power BI mostly due to the transitions that Power BI itself was going through. Then I stumbled on the RADACAD web site. Reza Rad touted a course that he taught named “Power BI, From Rookie to Rock star.” If the class was indeed an A to Z course, then it was exactly what I was looking for. The class outline seemed to include every topic on my checkoff list plus much more. I decided to give Reza a try.
Reza completely lived up to his hype. He took us through a natural progression of the software, using example after example of how to complete a task. We went through real world scenarios, a bare minimum of two scenarios for each minor topic. I was completely impressed with his Power BI knowledge, understanding and abilities. Any question we came to Reza with was answered completely and with even more examples.
After the class, my goal of immediately applying what I learned was attained. Right away I was able to successfully pull and massage data, create useful reports and post them to dashboards.
I would recommend Radacad Power BI Training without hesitation.

Jeffrey Weir; Independent Consultant, Wellington, New Zealand

I learned a lot from this course: it gave a great overview of what’s possible both right from the UI, and what more awaits if you lift the hood and pimp the engine. It’s incredible to see just how much PowerBI and PowerQuery radically simplify what I would otherwise have to do with many, many lines of complicated VBA code. And Reza is a masterful user of this tool.

Note that Reza covers a lot of ground in this course, and it is pretty fast paced. While you can take a laptop and follow along as Reza takes PowerBI/Powerquery through its paces, for the one-day course my recommendation would be to keep that laptop closed, and simply sit back and watch Reza in action, so you can fully concentrate on just how simple this tool is to use in the right hands as well as think about how you might use the tool to your own ends and ask questions along those lines. You can always purchase the video course (if it’s not already included in your course) and step through the material again at your own pace.

Rob Wilby; Independent Consultant, UK

I must say your “Power BI Essentials” course has been the most comprehensive Power BI course I have found to date and seeing how you work with data especially the little tricks naturally introduced at just the right moments has made this course a pleasure to take.

Martin Catherall – Data Platform MVP, PASS Regional Mentor

I attended Reza’s Power BI pre-con “From Rookie to Rock star” at SQL Saturday Brisbane in May 2016. I was a complete Power BI novice, having only previously accomplished a few very basic things with Power BI. Reza took the group through all the components that make up environment. He explained how they had evolved and took the group through walk-throughs of each one. Reza was great an answering questions from the audience at the event and going into extra detail if necessary. All-in all, I would say that I’m now a very confident Power BI user after attending Reza’s pre-con.

Dan Cheshire, Senior Project Manager Air New Zealand

Reza does not just know Power BI like the back of his hand, he is the most commercially aware BI person I know. He understands that companies work in the real world and that data isn’t always clean and needs manipulation for it to work and be useful. When Reza worked on our project, nothing phased or flustered him, he always came up with solutions for problems that seemed to me as insurmountable. Can’t recommend him enough, invest in Reza as he will not only save you a whole heap of time, but he comes up with long lasting and very powerful Power BI solutions for your business.

Sonia Buckley, Data Analyst at Zoom2u, Sydney, Australia

We have started to use Microsoft Power BI and whilst Microsoft tutorials are helpful, if you are not used to DAX then it is very difficult to get your head around and there is little other resources that don’t cost an arm and a leg. I had a call with Reza who made my life so much easier in just under an hour! Any time spent speaking to Reza will be well worth it – I have saved hours of trying to get my head around our dashboards by getting some very useful tips and explanations on why things are done the DAX way! Not only that but he is very patient and straight forward. Highly recommended!

R. Kemp, Canada

The course was an excellent investment overall, it exceed my expectations. It was well paced and presented. The instructor, Reza Rad, was excellent and was able to answer all my questions and explain complex idea in a manner that was easy to understand and follow. I had been using Power BI Desktop for a number of months prior to taking this course, but wish I had attended it sooner! The course structure of 1 day of overall Power BI and followed by 4 days of more intensive instruction on the various parts of Power BI allowed for a basic understanding of the whole, and then more comprehensive learning. The live-on-line experience worked well technically and allowed for questions and problem-solving with the instructor. I learned a lot about Power BI and this course gave me a great foundation for using Power BI to clean, model, design, and share reports using a variety of visualizations that will provide business intelligence to my company. I would recommend this course to anyone wanting to learn Power BI either as a starting point or even after you have used the tool to deepen your understanding and build your skill-set.

Who Attended RADACAD Training Courses

Register Here

Cancellation:
Cancellation up to 5 weeks before the event: full refund minus administration fee ($50) and credit-card processing fees (if applicable).

Cancellation from 5 weeks to 2 weeks before the event: 50% cancellation charge, 50% refund

Transfer fee to another event date* (from 2 weeks to 1 day before the event): 40% of the standard price of the event to transfer

Transfer fee at the day of event*: 60% of the standard price of the event to transfer

*transfer can be done only once, and it can be only transferred to another date not later than 6 months from the original event.
No Show:
No fee will be refunded for no show.

Save

Time

18 (Tuesday) 8:00 am - 19 (Wednesday) 4:00 pm GMT

Location

Auckland TBD

TBD

Organizer

Reza Radreza@radacad.com

Learn More

18jun - 19jun 188:00 am- 4:00 pmData Science Training - Module 3: Advanced Data Science with Microsoft Services – 2 Days Course Auckland Time Zone

Register Here

Course Title: Data Science and Advanced Analytics with Microsoft Technologies

Length:

From 1 to 7 days (Lecture + Labs): depends on the modules you enroll.

Delivery method:

In Person or Online: Check the schedule of upcoming courses.

Type of training:

Public or private (contact us for more details)

The course is scheduled for Auckland’s time zone from 8:00 Am to 4:00 PM each day.

This course is delivered to thousands of people all around the world, check out only a few of the recommendations at the bottom of this page, and check some of our clients.

Instructor: Dr. Leila Etaati

Advanced Analytics with Microsoft Technologies

Module 1: Power BI for Data Scientists (2 days)
Module 2: Data Science with Microsoft Cloud (2-days)
Module 3: Advanced Data Science with Microsoft Services (2-days)
Module 4: AI and Cognitive Services in Applications (1-day)

Module 3: Advanced Data Science with Microsoft Services – 2 days course

This training is designed for data science, data analysis and who want to do machine learning by writing R or Python code. This course will start with some explanation of different machine learning algorithms and approaches. Then, some discussion on basic statistical analysis will be provided such as probability, factor analysis, hypothesis testing and so forth. Then the process of machine learning from business understanding, data cleaning, feature selection, model selection, split data for testing and training, evaluating the created model and finally developing and visual the trained model and analyzing the result will be presented.

For predict analysis algorithms such as decision tree, boosted decision tree, decision forest will be explained. The concept and how they work will be explained. Then how to set parameters for each of them will be illustrated. Also, the process of data preparation for each of these algorithms will be discussed. Finally, the related code for writing this algorithm in the cloud will be explained. The same process will be done for the descriptive algorithms such as clustering.

In this two days training, the audience will learn some deep concepts for machine learning, data analysis, main algorithms for predictive, descriptive and statistical analysis using R, R in Power BI and SQL Server.

The training includes but not limited to topics below:

3.1: Machine Learning Basics

The main concepts, life cycle and best practice of doing machine learning with Microsoft product will be explained.

The main Predictive, descriptive and Prescriptive analysis will be explained
What are the main stages of machine learning cycle will be illustrated
- Business understanding
- Data cleaning and feature selection
- Model Selection
- Data training and testing
- Evaluating measures
- Writing codes

3.2: Predictive Analytics

In this section, the audience will learn some of the algorithms such as Decision tree, Decision Forest, regression and SVM for the aim of predictive analytics. The main concepts of these algorithms will be explained, and the related R or Python code will be shown. How to analysis the trained model and set up the parameters also will be discussed. Finally, how to evaluate the result will be explained.

What is classification and how to evaluate a classification result using confusion Matrix
Decision Tree, Decision Forest, and Boosted decision tree
SVM and KNN
How to do classification using decision tree in SQL Server 2016
How to classify by decision forest in Power BI
The main code for SVM and KNN and how to compare the results by writing R codes

3.3: Descriptive Analytics

Descriptive analytics is an unsupervised learning approach. In this part, the audience will be familiar with some of the main algorithms for descriptive analytics from text mining, clustering and, Market basket analytics.

The main concepts for clustering and k-mean clustering will be explained. Also, the process of identifying the number of clusters will be explained
The main process for text mining for the aim of sentiment analytics, keyword extraction, and language detection
How to do clustering in Power BI and how to use Power BI visual to analysis cluster
What is market basket analysis and what is support, confidence and lift measure
How to do Market basket analysis with R and rules package and how to show the result in Power BI visualization tools
Text mining concepts and main concepts

3.4: Forecasting

Forecasting is one of the main approaches for time series. The main concepts of the time series will be explained and how to decompose time series, how to use exponential smoothing and ARIMA for forecasting the time series data. Audience will learn

What is the forecasting
How to decompose time series data
What is Exponential smoothing and how to do it in RStudio and Power BI
What is ARIMA and how to do it in Power BI

In-Person Training;

https://radacad.com/events

Online Training;

https://radacad.com/events

Use the letter written for your boss to convince him/her to pay for your Power BI Training course

Check Schedule of upcoming events here

Check cancellation policies and rates here

What others say about the training and trainer

Kenny McMillan, Sports Physiologist / Data Analyst, Frankfurt, Germany:
I attended RADACADs “Advanced Analytics” course recently in Frankfurt in May 2017. Being a regular user of Power BI (with a science background ) the course was extremely helpful in showing me how to incorporate R data visualizations into Power BI dashboards and for introducing me to machine learning using the Microsoft ML Studio. Leila is an excellent and extremely knowledgeable instructor and explained complex data analytical concepts and methodologies in an easy-to-understand manner. I thoroughly recommend this course to anyone who wants to expand their data analytical skills and knowledge.

Martin Catherall (Microsoft Data Platform MVP):

As part of SQL Saturday Auckland 2016 I attended an “Analytics with Power BI and R.” pre-con with Leila. Leila took the class’s knowledge from rudimentary to competent in a day. We first looked at R, the language and the software. Once these skills were obtained we started to look at Power BI and the integration that it has with R. We worked through a few examples and Leila answered all of the class’s questions and offered to provide supplementary material for some of the more advanced questions. I left the class feeling that my R and Power BI knowledge was at a competent level and ready to dive into some of the more advanced material that Leila provided.

Who Attended RADACAD Training Courses

Cancellation:
Cancellation up to 5 weeks before the event: full refund minus administration fee ($50) and credit-card processing fees (if applicable).

Cancellation from 5 weeks to 2 weeks before the event: 50% cancellation charge, 50% refund

Transfer fee to another event date* (from 2 weeks to 1 day before the event): 40% of the standard price of the event to transfer

Transfer fee at the day of event*: 60% of the standard price of the event to transfer

*transfer can be done only once, and it can be only transferred to another date not later than 6 months from the original event.
No Show:
No fee will be refunded for no show.

Save

Time

18 (Tuesday) 8:00 am - 19 (Wednesday) 4:00 pm GMT

Location

Auckland TBD

Auckland, Auckland, New Zealand

Organizer

Leila Etaatileila@radacad.com

Learn More

8jul - 9jul 88:00 amjul 9Power BI from Rookie to Rock Star - Module 2: Power BI for Data Wrangler/Transformer (Data Transformation) – 2 days course, Sydney Australia

Register Here

Course Title: Power BI from Rookie to Rock Star

Length:

From 1 to 9 days (Lecture + Labs): depends on the modules you enrol.

Delivery method:

In-Person or Online: Check the schedule of upcoming courses.

Type of training:

Public or private (contact us for more details)

This course is delivered to thousands of people all around the world, check out only a few of the recommendations at the bottom of this page, and check some of our clients.

Instructor: Reza Rad

Power BI from Rookie to Rock Star

Module 1: Power BI for Data Analysts (2 days)
Module 2: Power BI for Data Wrangler and Transformer (2 days)
Module 3: Power BI for Data Modeler (2 days)
Module 4: Power BI for Architects (1 day)
Module 5: Power BI for Data Scientists (2 days)

Module 2: Power BI for Data Wrangler/Transformer (Data Transformation) – 2 days course

The training includes but not limited to topics below:

2.1: Get Data

Introduction to Power Query
Query Editor
Get Data from Web
Basic Transformations
Get Data from Excel
Use First Row As Headers / Use Headers as First Row
Get Data from SQL Server

2.2: Data Types and Data Structures

Base data structures in Power Query
Get Data from JSON
Transforming Table, Record, and List
Data Types in Power Query
Query Operations
Enable Load; Performance Boost
Query Operations; Duplicate, and Reference

2.3: Combine Queries

Dimensional Modelling; Designing the data model
Append, creating a single big query of the same structure
Merge; Joining queries when the structure is different
Join types in Merge
Tips to consider after Merge or Append

2.4: Better Power Query Editor Experience

Groups; Folders in Query Editor
Steps Operations
Splitting query steps
Moving steps up or down
Add as new query / Drill Down
Be Careful of Actions; Undo!

2.5: Reducing Number of Rows; Filtering

Row Operations; Removing rows
Row Operations; Keeping rows
Remove/Keep Errors
Remove/Keep Duplicates
Using Remove/Keep combination for troubleshooting report
Filtering based on Individual values
The dilemma of the basic filtering
Advanced Filtering
Sorting

2.6: Column Operations

Column Operations
Choosing Columns
Removing Columns
Data Type Change
Locale consideration for the data type
Replace Values
Fill Down/Up; Very Useful for Excel

2.7: Table Transformations

Group By; Changing the granularity of the data table
Group by Advanced
Scripting and Group by; First and Last item in each group
Transpose; rows to columns and reverse
Pivot; changing the name-value structure to columns
Unpivot; changing the budget column structure to rows

2.8: Text Transformations

Split Column by Delimiter
Split Column by number of Characters
Split into rows instead of columns
Merge (Concatenate)
Format
The difference between Clean and Trim
Parse (XML or JSON)
Extract part of the text

2.9: Numeric Transformations

Standard transformations; Divide, Integer-divide, Multiply, Add etc.
Scientific transformations; logarithm, power square, etc.
Statistics transformations;
Rounding
Information functions; Is Even, Is Odd, and Sign.
Dealing with faults in Numeric calculations

2.10: Date and Time Transformations

Date Transformations (Year, Month, Quarter, Week, etc.)
Extending Fiscal Date Column
Time Transformations (Hour, Minute, Second, etc.)
Adding Time/Date banding
Duration Transformation and Data Type
Age Calculation
Local Date or Time
Time zone consideration for Power BI

2.11: Structured Column Transformations

What is a Structured Column?
Expand
Aggregate
Expand and Aggregate: Performance Consideration

2.12: Add Column Transformations

Add Column vs. Transform?
Add Column with a Transformation
Index Column: Row Number
Conditional Column
Add Column by Example; When you don’t know which transformation to use
Add Custom Column: Generic

2.13: Functions and Parameters; Dynamic Power Query

Defining Parameters
Using Parameters in an existing query
Advanced GUI for parameters
Creating Function from a query
Invoking the sample function
Add Column Transform: Invoke Custom Function
When the advanced GUI does not exist

2.14: Power Query Formula Language: M

What is M? and the importance of learning M
M Syntax
End of the line
Variable Names
Special Characters
Escape Character
Step by Step Coding
Literals
Function Call
Comments
A real-world example

2.15: Working with Data Structures in M

Primitive Value
List
Record
Table
Function
Navigating through List and List functions
Navigating through Record and Record functions
Navigating through Table and table functions
Concatenating lists and records

2.16: Advanced M Scripting

#Shared Keyword; function library of Power Query
Parameters in the code
Custom Functions through scripting
Error Handling in Power Query
Generators in Power Query: Implementing Loop Structure
EACH: singleton function
Sample Custom Function: Day Number of Year Custom Function

2.17: Performance Tips and Tricks for Power Query

Enable Load; Simple, but Efficient
Reducing Number of Columns
Query Folding
Grouping and Aggregation; Performance Consideration
Merge; Before and After, things to Consider

2.18: Error Handling

Keep/Remove Errors; Troubleshooting report
Count Rows
Reference/Duplicate
Replace Errors
Data Type considerations

2.19: Use Cases

Date Dimension with Power Query; building the base table
Adding Fiscal columns to the Date dimension
Getting public holidays live and merging to the date dimension
Looping through files in a folder with Power Query

Register Here

Why Power BI Training?

Common Myths about Power BI

Myth 1: Power BI is a self-service Excel tool, and isn’t suitable for Enterprise Solutions.

Myth 2: Power BI is easy to use, and doesn’t require a training course.

Myth 3: Power BI is only for Microsoft based environments and platforms.

Myth 4: Power BI is not a powerful and fully functional BI tool, and cannot be compared with other tools in the market.

In addition, there is always the possibility to use this as a hybrid approach and save lots of time and money along with great features that are only available in this product.

In-Person Training;

https://radacad.com/events

Online Training;

https://radacad.com/events

Use the letter written for your boss to convince him/her to pay for your Power BI Training course

Check Schedule of upcoming events here

Check cancellation policies and rates here

What others say about the training and trainer

Daniel R Tuma, Senior Systems Analyst at Cleveland Metro Schools, Ohio, USA

I spent probably about two weeks looking for a good Microsoft Power BI class that would cover all of the aspects of the program. I wanted to walk away from the class being able to apply what I learned immediately. Most training companies that I looked into were in a state of flux with Power BI mostly due to the transitions that Power BI itself was going through. Then I stumbled on the RADACAD web site. Reza Rad touted a course that he taught named “Power BI, From Rookie to Rock star.” If the class was indeed an A to Z course, then it was exactly what I was looking for. The class outline seemed to include every topic on my checkoff list plus much more. I decided to give Reza a try.
Reza completely lived up to his hype. He took us through a natural progression of the software, using example after example of how to complete a task. We went through real world scenarios, a bare minimum of two scenarios for each minor topic. I was completely impressed with his Power BI knowledge, understanding and abilities. Any question we came to Reza with was answered completely and with even more examples.
After the class, my goal of immediately applying what I learned was attained. Right away I was able to successfully pull and massage data, create useful reports and post them to dashboards.
I would recommend Radacad Power BI Training without hesitation.

Jeffrey Weir; Independent Consultant, Wellington, New Zealand

I learned a lot from this course: it gave a great overview of what’s possible both right from the UI, and what more awaits if you lift the hood and pimp the engine. It’s incredible to see just how much PowerBI and PowerQuery radically simplify what I would otherwise have to do with many, many lines of complicated VBA code. And Reza is a masterful user of this tool.

Note that Reza covers a lot of ground in this course, and it is pretty fast paced. While you can take a laptop and follow along as Reza takes PowerBI/Powerquery through its paces, for the one-day course my recommendation would be to keep that laptop closed, and simply sit back and watch Reza in action, so you can fully concentrate on just how simple this tool is to use in the right hands as well as think about how you might use the tool to your own ends and ask questions along those lines. You can always purchase the video course (if it’s not already included in your course) and step through the material again at your own pace.

Rob Wilby; Independent Consultant, UK

I must say your “Power BI Essentials” course has been the most comprehensive Power BI course I have found to date and seeing how you work with data especially the little tricks naturally introduced at just the right moments has made this course a pleasure to take.

Martin Catherall – Data Platform MVP, PASS Regional Mentor

I attended Reza’s Power BI pre-con “From Rookie to Rock star” at SQL Saturday Brisbane in May 2016. I was a complete Power BI novice, having only previously accomplished a few very basic things with Power BI. Reza took the group through all the components that make up environment. He explained how they had evolved and took the group through walk-throughs of each one. Reza was great an answering questions from the audience at the event and going into extra detail if necessary. All-in all, I would say that I’m now a very confident Power BI user after attending Reza’s pre-con.

Dan Cheshire, Senior Project Manager Air New Zealand

Reza does not just know Power BI like the back of his hand, he is the most commercially aware BI person I know. He understands that companies work in the real world and that data isn’t always clean and needs manipulation for it to work and be useful. When Reza worked on our project, nothing phased or flustered him, he always came up with solutions for problems that seemed to me as insurmountable. Can’t recommend him enough, invest in Reza as he will not only save you a whole heap of time, but he comes up with long lasting and very powerful Power BI solutions for your business.

Sonia Buckley, Data Analyst at Zoom2u, Sydney, Australia

We have started to use Microsoft Power BI and whilst Microsoft tutorials are helpful, if you are not used to DAX then it is very difficult to get your head around and there is little other resources that don’t cost an arm and a leg. I had a call with Reza who made my life so much easier in just under an hour! Any time spent speaking to Reza will be well worth it – I have saved hours of trying to get my head around our dashboards by getting some very useful tips and explanations on why things are done the DAX way! Not only that but he is very patient and straight forward. Highly recommended!

R. Kemp, Canada

The course was an excellent investment overall, it exceed my expectations. It was well paced and presented. The instructor, Reza Rad, was excellent and was able to answer all my questions and explain complex idea in a manner that was easy to understand and follow. I had been using Power BI Desktop for a number of months prior to taking this course, but wish I had attended it sooner! The course structure of 1 day of overall Power BI and followed by 4 days of more intensive instruction on the various parts of Power BI allowed for a basic understanding of the whole, and then more comprehensive learning. The live-on-line experience worked well technically and allowed for questions and problem-solving with the instructor. I learned a lot about Power BI and this course gave me a great foundation for using Power BI to clean, model, design, and share reports using a variety of visualizations that will provide business intelligence to my company. I would recommend this course to anyone wanting to learn Power BI either as a starting point or even after you have used the tool to deepen your understanding and build your skill-set.

Who Attended RADACAD Training Courses

Register Here

Cancellation:
Cancellation up to 5 weeks before the event: full refund minus administration fee ($50) and credit-card processing fees (if applicable).

Cancellation from 5 weeks to 2 weeks before the event: 50% cancellation charge, 50% refund

Transfer fee to another event date* (from 2 weeks to 1 day before the event): 40% of the standard price of the event to transfer

Transfer fee at the day of event*: 60% of the standard price of the event to transfer

*transfer can be done only once, and it can be only transferred to another date not later than 6 months from the original event.
No Show:
No fee will be refunded for no show.

Save

Time

8 (Monday) 8:00 am - 9 (Tuesday) 4:00 pm AET

Location

Sydney TBD

Sydney

Organizer

Reza Radreza@radacad.com

Learn More

8jul - 9jul 88:00 amjul 9Data Science Training - Module 2: Data Science with Microsoft Cloud – 2 Days Course, Sydney Australia

Register Here

Course Title: Data Science and Advanced Analytics with Microsoft Technologies

Length:

From 1 to 7 days (Lecture + Labs): depends on the modules you enroll.

Delivery method:

In-Person or Online: Check the schedule of upcoming courses.

Type of training:

Public or private (contact us for more details)

This course is delivered to thousands of people all around the world, check out only a few of the recommendations at the bottom of this page, and check some of our clients.

Instructor: Dr. Leila Etaati

Advanced Analytics with Microsoft Technologies

Module 1: Power BI for Data Scientists (2 days)
Module 2: Data Science with Microsoft Cloud (2-days)
Module 3: Advanced Data Science with Microsoft Services (2-days)
Module 4: AI and Cognitive Services in Applications (1-day)

Module 2: Data Science with Microsoft Cloud – 2 days course

The training includes but not limited to topics below:

2.1: Azure Machine Learning (ML) Studio

In this section, you will learn some basic of machine learning and how it works. Then some introduction to Azure ML Studio will be provided.

Import data: The main component for importing data from local PC, how to import data from another workspace, how to import data from HTML website, how to import data from cloud such as Azure SQL DB.
Data Cleaning: data cleaning is the main process that we should do before any machine learning process. I will explain the available component in Azure ML. How to clean missing values, remove duplicate data, select column, clip value (remove outliers), group data into bins, and create an indicator for data. You will learn how to normalize the data, how to use SQL Statement for data transformation, how to use enter data manually, how to edit the data type, change the column name with edit metadata component, how to join data from different data resource , how to increase the number of low incidence in a dataset which unbalanced.
Feature Selection Data Sampling: the process of feature selection will be explained, how to split data, how to partition data using a sampling approach, how to create different folds for the aim of cross-validation.
Models: a bit talk about the available models in Azure mL for predictive, descriptive, prescriptive and anomaly detection. An example of a prediction of a group, a value, clustering data and anomaly detection will be shown. For each scenario, an example will be presented; different algorithms will apply to a problem. The main concepts of k-mean, how to use elbow chart to identify the number of the cluster will be discussed, the PCA chart will be explained. The trained model for recommendation “match box recommender” will be explained through a scenario. The main concepts of collaborative filtering and content-based filtering and hybrid approach for recommendation will be discussed.
Training and Scoring models: how to choose algorithms and how to train model and test model, what is cross-validation, how to do cross-validation to apply a model to different folds of data, how to check the different values for each parameter and see the related accuracy to that.
Evaluate: how to evaluate a classification problem concepts of Accuracy, Recall, Precision, AUC will be discussed, the evaluation criteria for regression algorithm MAE, RMSE and so on will be shown. How to evaluate and see the result of more than three algorithms on one dataset will be shown. Using different evaluate the model, enter data manually component and add row component.
Publish to Web: the process of creating a web service from a model will be discussed, how to check it in Excel will be shown, also how to use it in Stream Analytics as a function for data will be shown.
Sharing workspace, create projects: the process of how to share the workspace with others will be discussed, how to create a project for each experiment, how to create a trained model component for reuse, and a data transformed dataset, how to export datasets to CSV, and other formats will be shown.
Azure ML model in Power BI: Create a model in Azure ML Studio and use it in Power BI
Azure ML Model in IoT: the process of how to create a model in Azure ML model studio and apply it on streamed data.

2.2: Data science Virtual Machine

How to set it up
- Environment needs
- What parameter needs to be set up
What software and tools can be used
- visual studio and how to access R and Python
- Azure ML workbench
- SQL Server and Power BI
Deep learning introduction
Deep learning tools such as Tensor flow and so forth.
- Tensorflow
- Weka

2.3: Azure Data Lake Analytics

How to set up Azure Data Lake Store gen1 and Azure Data Lake Analytics
- Th main process of how to set them up will be explained
- How to access Azure Data Lake Analytics via visual studio also will be explained
How to use an existing sample of U-SQL
- An introduction into USQL
- How to run USQL in the cloud and how to run it
How to write R codes inside USQL
- How embed the R or Python code
- How to pass parameters and access the data
What is the best practice to create a machine learning project in data Lake
- How to create a model
- Store model
- And use the model for production

2.4: Azure Data Bricks

What is data bricks and how to set it up
The environment of data bricks and explain how they work
How to able to write R, Python, Scala, and SQL at the same time
Visualization of Databricks
Workspace and clusters
How to get information from Azure Data Lake store
How to get data from event Hub
What is notebook
How to pass data from one cell to other
How to use Databricks for a machine learning scenario storage model in Azure Data lake and show the result in Power BI

In-Person Training;

https://radacad.com/events

Online Training;

https://radacad.com/events

Use the letter written for your boss to convince him/her to pay for your Power BI Training course

Check Schedule of upcoming events here

Check cancellation policies and rates here

What others say about the training and trainer

Kenny McMillan, Sports Physiologist / Data Analyst, Frankfurt, Germany:
I attended RADACADs “Advanced Analytics” course recently in Frankfurt in May 2017. Being a regular user of Power BI (with a science background ) the course was extremely helpful in showing me how to incorporate R data visualizations into Power BI dashboards and for introducing me to machine learning using the Microsoft ML Studio. Leila is an excellent and extremely knowledgeable instructor and explained complex data analytical concepts and methodologies in an easy-to-understand manner. I thoroughly recommend this course to anyone who wants to expand their data analytical skills and knowledge.

Martin Catherall (Microsoft Data Platform MVP):

As part of SQL Saturday Auckland 2016 I attended an “Analytics with Power BI and R.” pre-con with Leila. Leila took the class’s knowledge from rudimentary to competent in a day. We first looked at R, the language and the software. Once these skills were obtained we started to look at Power BI and the integration that it has with R. We worked through a few examples and Leila answered all of the class’s questions and offered to provide supplementary material for some of the more advanced questions. I left the class feeling that my R and Power BI knowledge was at a competent level and ready to dive into some of the more advanced material that Leila provided.

Who Attended RADACAD Training Courses

Cancellation:
Cancellation up to 5 weeks before the event: full refund minus administration fee ($50) and credit-card processing fees (if applicable).

Cancellation from 5 weeks to 2 weeks before the event: 50% cancellation charge, 50% refund

Transfer fee to another event date* (from 2 weeks to 1 day before the event): 40% of the standard price of the event to transfer

Transfer fee at the day of event*: 60% of the standard price of the event to transfer

*transfer can be done only once, and it can be only transferred to another date not later than 6 months from the original event.
No Show:
No fee will be refunded for no show.

Save

Time

8 (Monday) 8:00 am - 9 (Tuesday) 4:00 pm AET

Location

Sydney TBD

Sydney

Organizer

Leila Etaatileila@radacad.com

Learn More

10jul - 11jul 108:00 amjul 11Power BI from Rookie to Rock Star - Module 3: Power BI for Data Modeler (Data Modelling and DAX) – 2 days course, Sydney Australia

Register Here

Course Title: Power BI from Rookie to Rock Star

Length:

From 1 to 9 days (Lecture + Labs): depends on the modules you enrol.

Delivery method:

In-Person or Online: Check the schedule of upcoming courses.

Type of training:

Public or private (contact us for more details)

This course is delivered to thousands of people all around the world, check out only a few of the recommendations at the bottom of this page, and check some of our clients.

Instructor: Reza Rad

Power BI from Rookie to Rock Star

Module 1: Power BI for Data Analysts (2 days)
Module 2: Power BI for Data Wrangler and Transformer (2 days)
Module 3: Power BI for Data Modeler (2 days)
Module 4: Power BI for Architects (1 day)
Module 5: Power BI for Data Scientists (2 days)

Module 3: Power BI for Data Modeler (Data Modelling and DAX) – 2 days course

The training includes but not limited to topics below:

3.1: Power BI Modelling 101

Basics of Modelling in Power BI
The step before this: Data Preparation
Relationships in Power BI; Filter propagation
Direction of Relationship
Be Careful of both directional relationship
Active or In-active relationships
Relationship based on multiple Columns
Role Playing Dimension
Formatting
Hide/Unhide Columns
Hierarchy Definition in Power BI
Sort by Column

3.2: Introduction to DAX

Syntax of DAX
Naming in DAX
Operators and Operands
Logical Operations
Data Types in Power BI Model
Overview of Functions in DAX
Variables
DAX or M? When to use Which?

3.3: Calculations in Power BI

Calculated Column; Row by Row
Measure; Single Output
Calculated Table; A derived table
Calculated Column? Maybe a good candidate for Power Query transformation
Measures are Dynamic

3.4: Aggregation and Iterator Functions

Aggregation Functions
Implicit Measures vs. Explicit Measures
Sum of an Expression: SumX
Iterator Functions
Difference between SUM and SUMX

3.5: Filter Functions

ALL
Filter Functions to be used inside other functions
Examples of using ALL function
ALL and SUMX; Percentage Calculation
AllExcept
Filter Function: Custom Filter
Values/Distinct; getting a unique list of values

3.6: Evaluation Contexts and Conditional Sum

Row Context
Filter Context
Exception for Row Context
Exception for Filter Context
Calculate Function
Conditional Sum; Three ways of Implementing; pros and Cons
Variables in DAX and using them for debugging

3.7: Relationship Functions

Related: Many to one
RelatedTable: Sub table that can be used as a filter
CrossFilter: Changing Direction of relationship
UseRelationship: using an inactive relationship
TreatAS function

3.8: Time Intelligence Functions

Choosing the Date Table: Built-in or Customized Date Table
Mark as Date Table
Year to Date, Quarter to Date
Fiscal Year to Date
Same Period Last Year
Year over Year Comparison
ParallelPeriod vs SamePeriodLastYear vs DateAdd
Running Total
Rolling 12 Month Sales
Average 12 Month Sales
Rolling 6 Months
Flexible time banding
Time zone consideration in Power BI

3.9: Dynamic DAX: Parameters

Numeric Parameter Definition through GUI
GenerateSeries DAX function
SelectedValue DAX function
Sample Scenario: Customer Retention with Dax and Power BI
Other Types of Parameters? Parameter Table
SWITCH
Sample Scenario: Selection of Measures in a table dynamically

3.10: Parent-Child Functions

Organizational Hierarchy or Chart of Accounts: unknown levels
Path function
PathLength: getting the number of levels
PathItem: finding a specific level
PathItemReverse
PathContains: Security Pattern
LookupValue: To get the other related fields

3.11: Best Practices Tips and Tricks

Modelling Best Practices
Understanding when to switch between Power Query and DAX
Considerations for very large tables
A tool that helps: Power BI Helper

Register Here

Why Power BI Training?

Common Myths about Power BI

Myth 1: Power BI is a self-service Excel tool, and isn’t suitable for Enterprise Solutions.

Myth 2: Power BI is easy to use, and doesn’t require a training course.

Myth 3: Power BI is only for Microsoft based environments and platforms.

Myth 4: Power BI is not a powerful and fully functional BI tool, and cannot be compared with other tools in the market.

In addition, there is always the possibility to use this as a hybrid approach and save lots of time and money along with great features that are only available in this product.

In-Person Training;

https://radacad.com/events

Online Training;

https://radacad.com/events

Use the letter written for your boss to convince him/her to pay for your Power BI Training course

Check Schedule of upcoming events here

Check cancellation policies and rates here

What others say about the training and trainer

Daniel R Tuma, Senior Systems Analyst at Cleveland Metro Schools, Ohio, USA

I spent probably about two weeks looking for a good Microsoft Power BI class that would cover all of the aspects of the program. I wanted to walk away from the class being able to apply what I learned immediately. Most training companies that I looked into were in a state of flux with Power BI mostly due to the transitions that Power BI itself was going through. Then I stumbled on the RADACAD web site. Reza Rad touted a course that he taught named “Power BI, From Rookie to Rock star.” If the class was indeed an A to Z course, then it was exactly what I was looking for. The class outline seemed to include every topic on my checkoff list plus much more. I decided to give Reza a try.
Reza completely lived up to his hype. He took us through a natural progression of the software, using example after example of how to complete a task. We went through real world scenarios, a bare minimum of two scenarios for each minor topic. I was completely impressed with his Power BI knowledge, understanding and abilities. Any question we came to Reza with was answered completely and with even more examples.
After the class, my goal of immediately applying what I learned was attained. Right away I was able to successfully pull and massage data, create useful reports and post them to dashboards.
I would recommend Radacad Power BI Training without hesitation.

Jeffrey Weir; Independent Consultant, Wellington, New Zealand

I learned a lot from this course: it gave a great overview of what’s possible both right from the UI, and what more awaits if you lift the hood and pimp the engine. It’s incredible to see just how much PowerBI and PowerQuery radically simplify what I would otherwise have to do with many, many lines of complicated VBA code. And Reza is a masterful user of this tool.

Note that Reza covers a lot of ground in this course, and it is pretty fast paced. While you can take a laptop and follow along as Reza takes PowerBI/Powerquery through its paces, for the one-day course my recommendation would be to keep that laptop closed, and simply sit back and watch Reza in action, so you can fully concentrate on just how simple this tool is to use in the right hands as well as think about how you might use the tool to your own ends and ask questions along those lines. You can always purchase the video course (if it’s not already included in your course) and step through the material again at your own pace.

Rob Wilby; Independent Consultant, UK

I must say your “Power BI Essentials” course has been the most comprehensive Power BI course I have found to date and seeing how you work with data especially the little tricks naturally introduced at just the right moments has made this course a pleasure to take.

Martin Catherall – Data Platform MVP, PASS Regional Mentor

I attended Reza’s Power BI pre-con “From Rookie to Rock star” at SQL Saturday Brisbane in May 2016. I was a complete Power BI novice, having only previously accomplished a few very basic things with Power BI. Reza took the group through all the components that make up environment. He explained how they had evolved and took the group through walk-throughs of each one. Reza was great an answering questions from the audience at the event and going into extra detail if necessary. All-in all, I would say that I’m now a very confident Power BI user after attending Reza’s pre-con.

Dan Cheshire, Senior Project Manager Air New Zealand

Reza does not just know Power BI like the back of his hand, he is the most commercially aware BI person I know. He understands that companies work in the real world and that data isn’t always clean and needs manipulation for it to work and be useful. When Reza worked on our project, nothing phased or flustered him, he always came up with solutions for problems that seemed to me as insurmountable. Can’t recommend him enough, invest in Reza as he will not only save you a whole heap of time, but he comes up with long lasting and very powerful Power BI solutions for your business.

Sonia Buckley, Data Analyst at Zoom2u, Sydney, Australia

We have started to use Microsoft Power BI and whilst Microsoft tutorials are helpful, if you are not used to DAX then it is very difficult to get your head around and there is little other resources that don’t cost an arm and a leg. I had a call with Reza who made my life so much easier in just under an hour! Any time spent speaking to Reza will be well worth it – I have saved hours of trying to get my head around our dashboards by getting some very useful tips and explanations on why things are done the DAX way! Not only that but he is very patient and straight forward. Highly recommended!

R. Kemp, Canada

The course was an excellent investment overall, it exceed my expectations. It was well paced and presented. The instructor, Reza Rad, was excellent and was able to answer all my questions and explain complex idea in a manner that was easy to understand and follow. I had been using Power BI Desktop for a number of months prior to taking this course, but wish I had attended it sooner! The course structure of 1 day of overall Power BI and followed by 4 days of more intensive instruction on the various parts of Power BI allowed for a basic understanding of the whole, and then more comprehensive learning. The live-on-line experience worked well technically and allowed for questions and problem-solving with the instructor. I learned a lot about Power BI and this course gave me a great foundation for using Power BI to clean, model, design, and share reports using a variety of visualizations that will provide business intelligence to my company. I would recommend this course to anyone wanting to learn Power BI either as a starting point or even after you have used the tool to deepen your understanding and build your skill-set.

Who Attended RADACAD Training Courses

Register Here

Cancellation:
Cancellation up to 5 weeks before the event: full refund minus administration fee ($50) and credit-card processing fees (if applicable).

Cancellation from 5 weeks to 2 weeks before the event: 50% cancellation charge, 50% refund

Transfer fee to another event date* (from 2 weeks to 1 day before the event): 40% of the standard price of the event to transfer

Transfer fee at the day of event*: 60% of the standard price of the event to transfer

*transfer can be done only once, and it can be only transferred to another date not later than 6 months from the original event.
No Show:
No fee will be refunded for no show.

Save

Time

10 (Wednesday) 8:00 am - 11 (Thursday) 4:00 pm AET

Location

Sydney TBD

Sydney

Organizer

Reza Radreza@radacad.com

Learn More

10jul - 11jul 108:00 amjul 11Data Science Training - Module 3: Advanced Data Science with Microsoft Services – 2 Days Course, Sydney Australia

Register Here

Course Title: Data Science and Advanced Analytics with Microsoft Technologies

Length:

From 1 to 7 days (Lecture + Labs): depends on the modules you enroll.

Delivery method:

In Person or Online: Check the schedule of upcoming courses.

Type of training:

Public or private (contact us for more details)

This course is delivered to thousands of people all around the world, check out only a few of the recommendations at the bottom of this page, and check some of our clients.

Instructor: Dr. Leila Etaati

Advanced Analytics with Microsoft Technologies

Module 1: Power BI for Data Scientists (2 days)
Module 2: Data Science with Microsoft Cloud (2-days)
Module 3: Advanced Data Science with Microsoft Services (2-days)
Module 4: AI and Cognitive Services in Applications (1-day)

Module 3: Advanced Data Science with Microsoft Services – 2 days course

The training includes but not limited to topics below:

3.1: Machine Learning Basics

The main concepts, life cycle and best practice of doing machine learning with Microsoft product will be explained.

The main Predictive, descriptive and Prescriptive analysis will be explained
What are the main stages of machine learning cycle will be illustrated
- Business understanding
- Data cleaning and feature selection
- Model Selection
- Data training and testing
- Evaluating measures
- Writing codes

3.2: Predictive Analytics

What is classification and how to evaluate a classification result using confusion Matrix
Decision Tree, Decision Forest, and Boosted decision tree
SVM and KNN
How to do classification using decision tree in SQL Server 2016
How to classify by decision forest in Power BI
The main code for SVM and KNN and how to compare the results by writing R codes

3.3: Descriptive Analytics

The main concepts for clustering and k-mean clustering will be explained. Also, the process of identifying the number of clusters will be explained
The main process for text mining for the aim of sentiment analytics, keyword extraction, and language detection
How to do clustering in Power BI and how to use Power BI visual to analysis cluster
What is market basket analysis and what is support, confidence and lift measure
How to do Market basket analysis with R and rules package and how to show the result in Power BI visualization tools
Text mining concepts and main concepts

3.4: Forecasting

What is the forecasting
How to decompose time series data
What is Exponential smoothing and how to do it in RStudio and Power BI
What is ARIMA and how to do it in Power BI

In-Person Training;

https://radacad.com/events

Online Training;

https://radacad.com/events

Use the letter written for your boss to convince him/her to pay for your Power BI Training course

Check Schedule of upcoming events here

Check cancellation policies and rates here

What others say about the training and trainer

Kenny McMillan, Sports Physiologist / Data Analyst, Frankfurt, Germany:
I attended RADACADs “Advanced Analytics” course recently in Frankfurt in May 2017. Being a regular user of Power BI (with a science background ) the course was extremely helpful in showing me how to incorporate R data visualizations into Power BI dashboards and for introducing me to machine learning using the Microsoft ML Studio. Leila is an excellent and extremely knowledgeable instructor and explained complex data analytical concepts and methodologies in an easy-to-understand manner. I thoroughly recommend this course to anyone who wants to expand their data analytical skills and knowledge.

Martin Catherall (Microsoft Data Platform MVP):

As part of SQL Saturday Auckland 2016 I attended an “Analytics with Power BI and R.” pre-con with Leila. Leila took the class’s knowledge from rudimentary to competent in a day. We first looked at R, the language and the software. Once these skills were obtained we started to look at Power BI and the integration that it has with R. We worked through a few examples and Leila answered all of the class’s questions and offered to provide supplementary material for some of the more advanced questions. I left the class feeling that my R and Power BI knowledge was at a competent level and ready to dive into some of the more advanced material that Leila provided.

Who Attended RADACAD Training Courses

Cancellation:
Cancellation up to 5 weeks before the event: full refund minus administration fee ($50) and credit-card processing fees (if applicable).

Cancellation from 5 weeks to 2 weeks before the event: 50% cancellation charge, 50% refund

Transfer fee to another event date* (from 2 weeks to 1 day before the event): 40% of the standard price of the event to transfer

Transfer fee at the day of event*: 60% of the standard price of the event to transfer

*transfer can be done only once, and it can be only transferred to another date not later than 6 months from the original event.
No Show:
No fee will be refunded for no show.

Save

Time

10 (Wednesday) 8:00 am - 11 (Thursday) 4:00 pm AET

Location

Sydney TBD

Sydney

Organizer

Leila Etaatileila@radacad.com

Learn More

12jul8:00 am- 4:00 amData Science Training - Module 4: AI and Cognitive Services in Applications - 1 Days Course, Sydney Australia

Register Here

Course Title: Data Science and Advanced Analytics with Microsoft Technologies

Length:

From 1 to 7 days (Lecture + Labs): depends on the modules you enroll.

Delivery method:

In-Person or Online: Check the schedule of upcoming courses.

Type of training:

Public or private (contact us for more details)

This course is delivered to thousands of people all around the world, check out only a few of the recommendations at the bottom of this page, and check some of our clients.

Instructor: Dr. Leila Etaati

Advanced Analytics with Microsoft Technologies

Module 1: Power BI for Data Scientists (2 days)
Module 2: Data Science with Microsoft Cloud (2-days)
Module 3: Advanced Data Science with Microsoft Services (2-days)
Module 4: AI and Cognitive Services in Applications (1-day)

Module 4: AI and Cognitive Services in Applications -1-day course

In this one-day training, the audience will get familiar with some AI tools available in Microsoft such as cognitive services, Bot framework, AI websites and so forth.

The main specifications of these tools are that there is no need to write R or python codes for the aim of machine learning.

In this one-day training audience will learn how to set up these AI tools in Azure, and how to use some of the cool AI websites like custom vision, QnA and so forth.

The training includes but not limited to topics below:

4.1: Cognitive Services

Microsoft Cognitive Services (formerly Project Oxford) are a set of APIs, SDKs and services available to developers to make their applications more intelligent, engaging and discoverable. Microsoft Cognitive Services expands on Microsoft’s evolving portfolio of machine learning APIs and enables developers to easily add intelligent features – such as emotion and video detection; facial, speech and vision recognition; and speech and language understanding – into their applications. In this section, below item will be explained

How to set up Cognitive services in Azure Portal
Using cognitive services for text analytics such as sentiment analytics, keyword extraction and topic extraction in Power BI
How to use cognitive services for handwriting detection and face recognition

4.2: Bot Framework

Azure Bot Service speeds up development by providing an integrated environment that’s purpose-built for bot development with the Microsoft Bot Framework connectors and BotBuilder SDKs. Developers can get started in seconds with out-of-the-box templates for scenarios including basic, form, language understanding, question and answer, and proactive bots.

How to set up the bot framework
How to use a bot for creating form and altering it in a .Net application
How to create Bot for the Question and Answer and embed it in Power BI or website
How to set up QnA

4.3: Application with Cognitive Service

There is a possibility to create an application in combination with Cognitive services. The audience will learn how to create a Face recognition API in .Net application for identifying the age, emotion, and so forth. Also, some more explanation of how to use Microsoft flow for creating a process to apply the cognitive services on the data. The process of how to set up the Flow using a template or to use a blank flow will be explained.

How to set up cognitive services for face recognition
Application C# for creating a web app
What is Microsoft Flow and how to use it
How to apply cognitive service on Twitter data

4.4: Create Model in Azure ML than in Power BI and Stream Analytics

There is a possibility to create a model in Azure, create an API out of it, then use it in Stream analytics for applying machine learning in live data will be explained. Moreover, how to use that model in Power BI also will be explained briefly.

Create a model in Azure ML Studio and a web service out of that
How to apply Azure ML API on a streamed data
How to use the created API on a dataset in Power BI

In-Person Training;

https://radacad.com/events

Online Training;

https://radacad.com/events

Use the letter written for your boss to convince him/her to pay for your Power BI Training course

Check Schedule of upcoming events here

Check cancellation policies and rates here

What others say about the training and trainer

Kenny McMillan, Sports Physiologist / Data Analyst, Frankfurt, Germany:
I attended RADACADs “Advanced Analytics” course recently in Frankfurt in May 2017. Being a regular user of Power BI (with a science background ) the course was extremely helpful in showing me how to incorporate R data visualizations into Power BI dashboards and for introducing me to machine learning using the Microsoft ML Studio. Leila is an excellent and extremely knowledgeable instructor and explained complex data analytical concepts and methodologies in an easy-to-understand manner. I thoroughly recommend this course to anyone who wants to expand their data analytical skills and knowledge.

Martin Catherall (Microsoft Data Platform MVP):

As part of SQL Saturday Auckland 2016 I attended an “Analytics with Power BI and R.” pre-con with Leila. Leila took the class’s knowledge from rudimentary to competent in a day. We first looked at R, the language and the software. Once these skills were obtained we started to look at Power BI and the integration that it has with R. We worked through a few examples and Leila answered all of the class’s questions and offered to provide supplementary material for some of the more advanced questions. I left the class feeling that my R and Power BI knowledge was at a competent level and ready to dive into some of the more advanced material that Leila provided.

Who Attended RADACAD Training Courses

Cancellation:
Cancellation up to 5 weeks before the event: full refund minus administration fee ($50) and credit-card processing fees (if applicable).

Cancellation from 5 weeks to 2 weeks before the event: 50% cancellation charge, 50% refund

Transfer fee to another event date* (from 2 weeks to 1 day before the event): 40% of the standard price of the event to transfer

Transfer fee at the day of event*: 60% of the standard price of the event to transfer

*transfer can be done only once, and it can be only transferred to another date not later than 6 months from the original event.
No Show:
No fee will be refunded for no show.

Save

Time

(Friday) 8:00 am - 4:00 am AET

Location

Sydney TBD

Sydney

Organizer

Leila Etaatileila@radacad.com

Learn More

12jul8:00 am- 4:00 pmPower BI from Rookie to Rock Star - Module 4: Power BI for Data Architects (Architecture and Administration) – 1-day course, Sydney Australia

Register Here

Course Title: Power BI from Rookie to Rock Star

Length:

From 1 to 9 days (Lecture + Labs): depends on the modules you enrol.

Delivery method:

In-Person or Online: Check the schedule of upcoming courses.

Type of training:

Public or private (contact us for more details)

This course is delivered to thousands of people all around the world, check out only a few of the recommendations at the bottom of this page, and check some of our clients.

Instructor: Reza Rad

Power BI from Rookie to Rock Star

Module 1: Power BI for Data Analysts (2 days)
Module 2: Power BI for Data Wrangler and Transformer (2 days)
Module 3: Power BI for Data Modeler (2 days)
Module 4: Power BI for Architects (1 day)
Module 5: Power BI for Data Scientists (2 days)

Module 4: Power BI for Data Architects (Architecture and Administration) – 1-day course

This training is designed for data architect or administrator, who is designing the architecture of leveraging Power BI in a solution. Someone who wants to understand how all components of Power BI are sitting beside each other to build the whole solution. This training is designed for understanding the strategy of using Power BI rather than the development of it.

In this training, you will learn about architecting the strategy of a Power BI solution from end to end. This is not training about development (Modules 1 to 3 already covered that). You do not need to attend previous modules to attend this course. This course is designed separately from those. However, knowing some of the basics of Power BI is helpful.

You will learn about Power BI Service, and different types of connections in Power BI and choose the right type of connection for your solution. You will also learn all different ways of sharing a Power BI Solution and the pros and cons of each. The course continues with a detailed discussion about row-level security. You will learn how gateway configuration and set up will be in the whole package. You will also learn about integrating Power BI with other tools, and some architecture blueprints to follow when you are designing a Power BI solution.

The training includes but not limited to topics below:

4.1: Power BI Service

Power BI service or website plays an important role in designing a Power BI solution. Power BI website is the hosting environment for Power BI reports, dashboards and datasets. In this section, you will learn about these objects and their configuration. You will also learn about the different types of connections in Power BI, and the position of the gateway in the solution, configuring and installing it.

Power BI Components
Power BI Service Content; Dashboard, Report, and Dataset
Dashboard Features in the service
What is Gateway?
Two types of Gateway; On-premises, Personal
Configuration and Installation of Gateway
Import Data and Schedule Refresh
DirectQuery Connection
Live Connection
Composite Model

4.2: Sharing

There are several ways of sharing Power BI reports and dashboards. Each of the methods has pros and cons and should be used in specific scenarios. In this section, you will learn scenarios to use each of these methods for sharing, and the sharing of architecture, and a comparison between all these methods at the end.

Basic Dashboard or Report Sharing
Workspaces in Power BI; Dev Environment
Power BI Apps; User Environment
Publish to Web
Embed in SharePoint Online; Office 365 Integrated Sharing
Power BI Embedded; Embedding content into another application
Comparison of all Sharing methods

4.3: Security

Sharing is about giving users access to the entire content; security is about giving them access to part of it. There are different ways of implementing security (which is called row-level security in Power BI). Statics row-level security is a good option when roles are limited items. The next level is to define a dynamic row-level security using DAX functions. Dynamic row-level security comes as different patterns which will be discussed here through examples.

Row Level Security
Dynamic Row Level Security
Patterns for Dynamic Row Level Security
Manager Level Access
Organization Chart Access as Dynamic Row Level Security
Profiles and Users; Dynamic Row Level Security
Dynamic Row Level Security using SQL Server Analysis Service Live Connection

4.4: Administration and Licensing

As a Power BI administrator, you need to have a careful eye on some of the metrics, and control some of the settings across your organization Power BI tenant. In this section, you will learn about Power BI administrator configuration options and options which are critical to controlling. You will also learn about all licensing options for Power BI and will have a clear view of what would be the best licensing option for you.

Power BI Administrator Configuration
Usage Metrics
Customizing Usage Metrics
Power BI Licensing Guide
Power BI Premium
Power BI Embedded Licensing

4.5: Integration

Power BI can integrate with other tools and services such as Reporting Services and Excel. In this section, you will learn about all integration options for Power BI. This section will also give you a full understanding of Power BI Report Server; the on-premises usage of Power BI. You will learn Power BI REST API capabilities (not at a developer level, more in architecture level), and you will learn about real-time streaming options available with Power BI.

PowerPoint Integration with Power BI
Power BI and Excel; More than just an Integration
Power BI Report Server: Power BI on-premises
SQL Server Reporting Services Integration with Power BI
Real-time Streaming with Power BI, and Azure Stream Analytics
Power BI REST API

4.6: Architecture

The last part of the training focuses on architecture blueprints for Power BI. In addition to architecture best practices for sharing, self-service, enterprise-level architecture, you will learn about a tool that can help in Power BI solution designed by RADACAD; Power BI Helper.

Architecture for Enterprise Scale
Architecture for Sharing
Architecture for Self-Service
A tool that helps: Power BI Helper

Register Here

Why Power BI Training?

Common Myths about Power BI

Myth 1: Power BI is a self-service Excel tool, and isn’t suitable for Enterprise Solutions.

Myth 2: Power BI is easy to use, and doesn’t require a training course.

Myth 3: Power BI is only for Microsoft based environments and platforms.

Myth 4: Power BI is not a powerful and fully functional BI tool, and cannot be compared with other tools in the market.

In addition, there is always the possibility to use this as a hybrid approach and save lots of time and money along with great features that are only available in this product.

In-Person Training;

https://radacad.com/events

Online Training;

https://radacad.com/events

Use the letter written for your boss to convince him/her to pay for your Power BI Training course

Check Schedule of upcoming events here

Check cancellation policies and rates here

What others say about the training and trainer

Daniel R Tuma, Senior Systems Analyst at Cleveland Metro Schools, Ohio, USA

I spent probably about two weeks looking for a good Microsoft Power BI class that would cover all of the aspects of the program. I wanted to walk away from the class being able to apply what I learned immediately. Most training companies that I looked into were in a state of flux with Power BI mostly due to the transitions that Power BI itself was going through. Then I stumbled on the RADACAD web site. Reza Rad touted a course that he taught named “Power BI, From Rookie to Rock star.” If the class was indeed an A to Z course, then it was exactly what I was looking for. The class outline seemed to include every topic on my checkoff list plus much more. I decided to give Reza a try.
Reza completely lived up to his hype. He took us through a natural progression of the software, using example after example of how to complete a task. We went through real world scenarios, a bare minimum of two scenarios for each minor topic. I was completely impressed with his Power BI knowledge, understanding and abilities. Any question we came to Reza with was answered completely and with even more examples.
After the class, my goal of immediately applying what I learned was attained. Right away I was able to successfully pull and massage data, create useful reports and post them to dashboards.
I would recommend Radacad Power BI Training without hesitation.

Jeffrey Weir; Independent Consultant, Wellington, New Zealand

I learned a lot from this course: it gave a great overview of what’s possible both right from the UI, and what more awaits if you lift the hood and pimp the engine. It’s incredible to see just how much PowerBI and PowerQuery radically simplify what I would otherwise have to do with many, many lines of complicated VBA code. And Reza is a masterful user of this tool.

Note that Reza covers a lot of ground in this course, and it is pretty fast paced. While you can take a laptop and follow along as Reza takes PowerBI/Powerquery through its paces, for the one-day course my recommendation would be to keep that laptop closed, and simply sit back and watch Reza in action, so you can fully concentrate on just how simple this tool is to use in the right hands as well as think about how you might use the tool to your own ends and ask questions along those lines. You can always purchase the video course (if it’s not already included in your course) and step through the material again at your own pace.

Rob Wilby; Independent Consultant, UK

I must say your “Power BI Essentials” course has been the most comprehensive Power BI course I have found to date and seeing how you work with data especially the little tricks naturally introduced at just the right moments has made this course a pleasure to take.

Martin Catherall – Data Platform MVP, PASS Regional Mentor

I attended Reza’s Power BI pre-con “From Rookie to Rock star” at SQL Saturday Brisbane in May 2016. I was a complete Power BI novice, having only previously accomplished a few very basic things with Power BI. Reza took the group through all the components that make up environment. He explained how they had evolved and took the group through walk-throughs of each one. Reza was great an answering questions from the audience at the event and going into extra detail if necessary. All-in all, I would say that I’m now a very confident Power BI user after attending Reza’s pre-con.

Dan Cheshire, Senior Project Manager Air New Zealand

Reza does not just know Power BI like the back of his hand, he is the most commercially aware BI person I know. He understands that companies work in the real world and that data isn’t always clean and needs manipulation for it to work and be useful. When Reza worked on our project, nothing phased or flustered him, he always came up with solutions for problems that seemed to me as insurmountable. Can’t recommend him enough, invest in Reza as he will not only save you a whole heap of time, but he comes up with long lasting and very powerful Power BI solutions for your business.

Sonia Buckley, Data Analyst at Zoom2u, Sydney, Australia

We have started to use Microsoft Power BI and whilst Microsoft tutorials are helpful, if you are not used to DAX then it is very difficult to get your head around and there is little other resources that don’t cost an arm and a leg. I had a call with Reza who made my life so much easier in just under an hour! Any time spent speaking to Reza will be well worth it – I have saved hours of trying to get my head around our dashboards by getting some very useful tips and explanations on why things are done the DAX way! Not only that but he is very patient and straight forward. Highly recommended!

R. Kemp, Canada

The course was an excellent investment overall, it exceed my expectations. It was well paced and presented. The instructor, Reza Rad, was excellent and was able to answer all my questions and explain complex idea in a manner that was easy to understand and follow. I had been using Power BI Desktop for a number of months prior to taking this course, but wish I had attended it sooner! The course structure of 1 day of overall Power BI and followed by 4 days of more intensive instruction on the various parts of Power BI allowed for a basic understanding of the whole, and then more comprehensive learning. The live-on-line experience worked well technically and allowed for questions and problem-solving with the instructor. I learned a lot about Power BI and this course gave me a great foundation for using Power BI to clean, model, design, and share reports using a variety of visualizations that will provide business intelligence to my company. I would recommend this course to anyone wanting to learn Power BI either as a starting point or even after you have used the tool to deepen your understanding and build your skill-set.

Who Attended RADACAD Training Courses

Register Here

Cancellation:
Cancellation up to 5 weeks before the event: full refund minus administration fee ($50) and credit-card processing fees (if applicable).

Cancellation from 5 weeks to 2 weeks before the event: 50% cancellation charge, 50% refund

Transfer fee to another event date* (from 2 weeks to 1 day before the event): 40% of the standard price of the event to transfer

Transfer fee at the day of event*: 60% of the standard price of the event to transfer

*transfer can be done only once, and it can be only transferred to another date not later than 6 months from the original event.
No Show:
No fee will be refunded for no show.

Save

Time

(Friday) 8:00 am - 4:00 pm AET

Location

Sydney

Sydney TBD

Organizer

Reza Radreza@radacad.com

Learn More

23jul8:00 am- 4:00 pmPower BI from Rookie to Rock Star - Module 4: Power BI for Data Architects (Architecture and Administration) – 1-day course Auckland Time Zone

Register Here

Course Title: Power BI from Rookie to Rock Star

Length:

From 1 to 9 days (Lecture + Labs): depends on the modules you enrol.

Delivery method:

In-Person or Online: Check the schedule of upcoming courses.

Type of training:

Public or private (contact us for more details)

The course is scheduled for Auckland’s time zone from 8:00 Am to 4:00 PM each day.

This course is delivered to thousands of people all around the world, check out only a few of the recommendations at the bottom of this page, and check some of our clients.

Instructor: Reza Rad

Power BI from Rookie to Rock Star

Module 1: Power BI for Data Analysts (2 days)
Module 2: Power BI for Data Wrangler and Transformer (2 days)
Module 3: Power BI for Data Modeler (2 days)
Module 4: Power BI for Architects (1 day)
Module 5: Power BI for Data Scientists (2 days)

Module 4: Power BI for Data Architects (Architecture and Administration) – 1-day course

The training includes but not limited to topics below:

4.1: Power BI Service

Power BI Components
Power BI Service Content; Dashboard, Report, and Dataset
Dashboard Features in the service
What is Gateway?
Two types of Gateway; On-premises, Personal
Configuration and Installation of Gateway
Import Data and Schedule Refresh
DirectQuery Connection
Live Connection
Composite Model

4.2: Sharing

Basic Dashboard or Report Sharing
Workspaces in Power BI; Dev Environment
Power BI Apps; User Environment
Publish to Web
Embed in SharePoint Online; Office 365 Integrated Sharing
Power BI Embedded; Embedding content into another application
Comparison of all Sharing methods

4.3: Security

Row Level Security
Dynamic Row Level Security
Patterns for Dynamic Row Level Security
Manager Level Access
Organization Chart Access as Dynamic Row Level Security
Profiles and Users; Dynamic Row Level Security
Dynamic Row Level Security using SQL Server Analysis Service Live Connection

4.4: Administration and Licensing

Power BI Administrator Configuration
Usage Metrics
Customizing Usage Metrics
Power BI Licensing Guide
Power BI Premium
Power BI Embedded Licensing

4.5: Integration

PowerPoint Integration with Power BI
Power BI and Excel; More than just an Integration
Power BI Report Server: Power BI on-premises
SQL Server Reporting Services Integration with Power BI
Real-time Streaming with Power BI, and Azure Stream Analytics
Power BI REST API

4.6: Architecture

Architecture for Enterprise Scale
Architecture for Sharing
Architecture for Self-Service
A tool that helps: Power BI Helper

Register Here

Why Power BI Training?

Common Myths about Power BI

Myth 1: Power BI is a self-service Excel tool, and isn’t suitable for Enterprise Solutions.

Myth 2: Power BI is easy to use, and doesn’t require a training course.

Myth 3: Power BI is only for Microsoft based environments and platforms.

Myth 4: Power BI is not a powerful and fully functional BI tool, and cannot be compared with other tools in the market.

In addition, there is always the possibility to use this as a hybrid approach and save lots of time and money along with great features that are only available in this product.

In-Person Training;

https://radacad.com/events

Online Training;

https://radacad.com/events

Use the letter written for your boss to convince him/her to pay for your Power BI Training course

Check Schedule of upcoming events here

Check cancellation policies and rates here

What others say about the training and trainer

Daniel R Tuma, Senior Systems Analyst at Cleveland Metro Schools, Ohio, USA

I spent probably about two weeks looking for a good Microsoft Power BI class that would cover all of the aspects of the program. I wanted to walk away from the class being able to apply what I learned immediately. Most training companies that I looked into were in a state of flux with Power BI mostly due to the transitions that Power BI itself was going through. Then I stumbled on the RADACAD web site. Reza Rad touted a course that he taught named “Power BI, From Rookie to Rock star.” If the class was indeed an A to Z course, then it was exactly what I was looking for. The class outline seemed to include every topic on my checkoff list plus much more. I decided to give Reza a try.
Reza completely lived up to his hype. He took us through a natural progression of the software, using example after example of how to complete a task. We went through real world scenarios, a bare minimum of two scenarios for each minor topic. I was completely impressed with his Power BI knowledge, understanding and abilities. Any question we came to Reza with was answered completely and with even more examples.
After the class, my goal of immediately applying what I learned was attained. Right away I was able to successfully pull and massage data, create useful reports and post them to dashboards.
I would recommend Radacad Power BI Training without hesitation.

Jeffrey Weir; Independent Consultant, Wellington, New Zealand

I learned a lot from this course: it gave a great overview of what’s possible both right from the UI, and what more awaits if you lift the hood and pimp the engine. It’s incredible to see just how much PowerBI and PowerQuery radically simplify what I would otherwise have to do with many, many lines of complicated VBA code. And Reza is a masterful user of this tool.

Note that Reza covers a lot of ground in this course, and it is pretty fast paced. While you can take a laptop and follow along as Reza takes PowerBI/Powerquery through its paces, for the one-day course my recommendation would be to keep that laptop closed, and simply sit back and watch Reza in action, so you can fully concentrate on just how simple this tool is to use in the right hands as well as think about how you might use the tool to your own ends and ask questions along those lines. You can always purchase the video course (if it’s not already included in your course) and step through the material again at your own pace.

Rob Wilby; Independent Consultant, UK

I must say your “Power BI Essentials” course has been the most comprehensive Power BI course I have found to date and seeing how you work with data especially the little tricks naturally introduced at just the right moments has made this course a pleasure to take.

Martin Catherall – Data Platform MVP, PASS Regional Mentor

I attended Reza’s Power BI pre-con “From Rookie to Rock star” at SQL Saturday Brisbane in May 2016. I was a complete Power BI novice, having only previously accomplished a few very basic things with Power BI. Reza took the group through all the components that make up environment. He explained how they had evolved and took the group through walk-throughs of each one. Reza was great an answering questions from the audience at the event and going into extra detail if necessary. All-in all, I would say that I’m now a very confident Power BI user after attending Reza’s pre-con.

Dan Cheshire, Senior Project Manager Air New Zealand

Reza does not just know Power BI like the back of his hand, he is the most commercially aware BI person I know. He understands that companies work in the real world and that data isn’t always clean and needs manipulation for it to work and be useful. When Reza worked on our project, nothing phased or flustered him, he always came up with solutions for problems that seemed to me as insurmountable. Can’t recommend him enough, invest in Reza as he will not only save you a whole heap of time, but he comes up with long lasting and very powerful Power BI solutions for your business.

Sonia Buckley, Data Analyst at Zoom2u, Sydney, Australia

We have started to use Microsoft Power BI and whilst Microsoft tutorials are helpful, if you are not used to DAX then it is very difficult to get your head around and there is little other resources that don’t cost an arm and a leg. I had a call with Reza who made my life so much easier in just under an hour! Any time spent speaking to Reza will be well worth it – I have saved hours of trying to get my head around our dashboards by getting some very useful tips and explanations on why things are done the DAX way! Not only that but he is very patient and straight forward. Highly recommended!

R. Kemp, Canada

The course was an excellent investment overall, it exceed my expectations. It was well paced and presented. The instructor, Reza Rad, was excellent and was able to answer all my questions and explain complex idea in a manner that was easy to understand and follow. I had been using Power BI Desktop for a number of months prior to taking this course, but wish I had attended it sooner! The course structure of 1 day of overall Power BI and followed by 4 days of more intensive instruction on the various parts of Power BI allowed for a basic understanding of the whole, and then more comprehensive learning. The live-on-line experience worked well technically and allowed for questions and problem-solving with the instructor. I learned a lot about Power BI and this course gave me a great foundation for using Power BI to clean, model, design, and share reports using a variety of visualizations that will provide business intelligence to my company. I would recommend this course to anyone wanting to learn Power BI either as a starting point or even after you have used the tool to deepen your understanding and build your skill-set.

Who Attended RADACAD Training Courses

Register Here

Cancellation:
Cancellation up to 5 weeks before the event: full refund minus administration fee ($50) and credit-card processing fees (if applicable).

Cancellation from 5 weeks to 2 weeks before the event: 50% cancellation charge, 50% refund

Transfer fee to another event date* (from 2 weeks to 1 day before the event): 40% of the standard price of the event to transfer

Transfer fee at the day of event*: 60% of the standard price of the event to transfer

*transfer can be done only once, and it can be only transferred to another date not later than 6 months from the original event.
No Show:
No fee will be refunded for no show.

Save

Time

(Tuesday) 8:00 am - 4:00 pm

Organizer

Reza Radreza@radacad.com

Learn More

23jul8:00 am- 4:00 amData Science Training - Module 4: AI and Cognitive Services in Applications - Auckland 1 Days Course

Register Here

Course Title: Data Science and Advanced Analytics with Microsoft Technologies

Length:

From 1 to 7 days (Lecture + Labs): depends on the modules you enroll.

Delivery method:

In-Person or Online: Check the schedule of upcoming courses.

Type of training:

Public or private (contact us for more details)

The course is scheduled for Auckland’s time zone from 8:00 Am to 4:00 PM each day.

This course is delivered to thousands of people all around the world, check out only a few of the recommendations at the bottom of this page, and check some of our clients.

Instructor: Dr. Leila Etaati

Advanced Analytics with Microsoft Technologies

Module 1: Power BI for Data Scientists (2 days)
Module 2: Data Science with Microsoft Cloud (2-days)
Module 3: Advanced Data Science with Microsoft Services (2-days)
Module 4: AI and Cognitive Services in Applications (1-day)

Module 4: AI and Cognitive Services in Applications -1-day course

In this one-day training, the audience will get familiar with some AI tools available in Microsoft such as cognitive services, Bot framework, AI websites and so forth.

The main specifications of these tools are that there is no need to write R or python codes for the aim of machine learning.

In this one-day training audience will learn how to set up these AI tools in Azure, and how to use some of the cool AI websites like custom vision, QnA and so forth.

The training includes but not limited to topics below:

4.1: Cognitive Services

How to set up Cognitive services in Azure Portal
Using cognitive services for text analytics such as sentiment analytics, keyword extraction and topic extraction in Power BI
How to use cognitive services for handwriting detection and face recognition

4.2: Bot Framework

How to set up the bot framework
How to use a bot for creating form and altering it in a .Net application
How to create Bot for the Question and Answer and embed it in Power BI or website
How to set up QnA

4.3: Application with Cognitive Service

How to set up cognitive services for face recognition
Application C# for creating a web app
What is Microsoft Flow and how to use it
How to apply cognitive service on Twitter data

4.4: Create Model in Azure ML than in Power BI and Stream Analytics

Create a model in Azure ML Studio and a web service out of that
How to apply Azure ML API on a streamed data
How to use the created API on a dataset in Power BI

In-Person Training;

https://radacad.com/events

Online Training;

https://radacad.com/events

Use the letter written for your boss to convince him/her to pay for your Power BI Training course

Check Schedule of upcoming events here

Check cancellation policies and rates here

What others say about the training and trainer

Kenny McMillan, Sports Physiologist / Data Analyst, Frankfurt, Germany:
I attended RADACADs “Advanced Analytics” course recently in Frankfurt in May 2017. Being a regular user of Power BI (with a science background ) the course was extremely helpful in showing me how to incorporate R data visualizations into Power BI dashboards and for introducing me to machine learning using the Microsoft ML Studio. Leila is an excellent and extremely knowledgeable instructor and explained complex data analytical concepts and methodologies in an easy-to-understand manner. I thoroughly recommend this course to anyone who wants to expand their data analytical skills and knowledge.

Martin Catherall (Microsoft Data Platform MVP):

As part of SQL Saturday Auckland 2016 I attended an “Analytics with Power BI and R.” pre-con with Leila. Leila took the class’s knowledge from rudimentary to competent in a day. We first looked at R, the language and the software. Once these skills were obtained we started to look at Power BI and the integration that it has with R. We worked through a few examples and Leila answered all of the class’s questions and offered to provide supplementary material for some of the more advanced questions. I left the class feeling that my R and Power BI knowledge was at a competent level and ready to dive into some of the more advanced material that Leila provided.

Who Attended RADACAD Training Courses

Cancellation:
Cancellation up to 5 weeks before the event: full refund minus administration fee ($50) and credit-card processing fees (if applicable).

Cancellation from 5 weeks to 2 weeks before the event: 50% cancellation charge, 50% refund

Transfer fee to another event date* (from 2 weeks to 1 day before the event): 40% of the standard price of the event to transfer

Transfer fee at the day of event*: 60% of the standard price of the event to transfer

*transfer can be done only once, and it can be only transferred to another date not later than 6 months from the original event.
No Show:
No fee will be refunded for no show.

Save

Time

(Tuesday) 8:00 am - 4:00 am CET

Location

Auckland TBD

TBD

Organizer

Leila Etaatileila@radacad.com

Learn More

13aug - 14aug 138:00 amaug 14Data Science Training - Module 1: Power BI for Data Scientist – 2 Days Course Auckland Time Zone

Register Here

Course Title: Power BI from Rookie to Rock Star

Length:

From 1 to 9 days (Lecture + Labs): depends on the modules you enrol.

Delivery method:

In-Person or Online: Check the schedule of upcoming courses.

Type of training:

Public or private (contact us for more details)

The course is scheduled for Auckland’s time zone from 8:00 Am to 4:00 PM each day.

This course is delivered to thousands of people all around the world, check out only a few of the recommendations at the bottom of this page, and check some of our clients.

Instructor: Dr. Leila Etaati

Advanced Analytics with Microsoft Technologies

Module 1: Power BI for Data Scientists (2 days)
Module 2: Data Science with Microsoft Cloud (2-days)
Module 3: Advanced Data Science with Microsoft Services (2-days)
Module 4: AI and Cognitive Services in Applications (1-day)

Module 1: Power BI for Data Scientists – 2 days course

This training is designed for people who want to do Machine Learning (ML) inside Power BI. In this training, you will learn different ways to use R languages for the aim of machine learning, visualization, data cleaning in Power BI.

In this two days training, you will learn some main concepts of machine learning. You will learn some basics of R language and How to use it in Power BI visualization, Power Query (data wrangler part of Power BI), and how to use it for creating custom visual. Also, the training will cover some of the main algorithms for machine learning such as Predictive analytics (Decision-Tree, Decision Forest, KNN, SVM), Descriptive analysis (Clustering, Market Basket Analysis) and Forecasting (Time Series). Finally the pre-build advanced analytics visual in Power BI Marketplace will be explained and how to use them will be clarified.

At the end of this training, you will able to write R code in Power BI report and Power Query, create custom visual with the help of JSON codes and R scripts,

The training includes but not limited to topics below:

1.1: Introduction to R

R is a statistical language that has been used for many years for the aim of machine learning, statistical analytics, data wrangling, data visualization and so forth. There is a possibility to embed R codes inside Power BI to create more smart applications. In this module, we will go through the basics of R language and introduce some of the main R functions and commands such as statistical summary, package concepts, read data from SQL Server, Azure and so forth, visualization command, loop, and so forth. You will see some demos and introduction about:

Introduction to R Language: What is R?
RStudio; The First Experience
- Install Rstudio
- RStudio Environment
R basic Command
- Data Structure such as Data Frame, Vector, and Lists
- Import Data from the local machine, SQL Server, Azure Data Lake and so forth.
- Check the Statistical Summary of data
- Check the Structure Summary of Data
- Use existing Package and how to Install New Packages
- Create Basic Chart such as Histogram and Box Plot for better Understanding data
- And some other useful commands

1.2: Introduction to Machine Learning

In this section, some introduction to Machine learning will be provided. The audience will learn what Artificial Intelligence is, what is Machine Learning, who is Data Scientists, who is data Analyst, and What is Deep learning. Also, some explanations on what descriptive and predictive analytics are will be provided. In this module audience will learn:

What is Descriptive Analytics
What is Predictive Analytics
What is Forecasting
What Languages exist for Machine Learning and what is the main difference

1.3: Use R in Power BI Report for Visualization

Power BI consists of different components such as Power BI visualization, Power Query, Power BI services and so forth. Power BI visualization has lots of interesting and useful chart to visual data and creates business reports. However, customer need can be varied; each customer may need different visual that not available in Power BI visualization pan. In this module

How to set up R in Power BI visualization will be explained
How to use R visual in Power BI will be shown
R editor in Power BI will be explained, and all feature such as setting, how to debug code in RStudio, and how to run will be explained.
How to draw some basic charts like Histogram, Boxplot, table (gride) will be shown.
The audience will see how to use the ggplot2 package for drawing the more complex visualization
They will learn how to create a table chart with four, and five dimensions
The audience will learn how to create different bar chart, polar chart by writing simple R codes
How to create a colorful chart in Power BI using R will be explained

1.4: Use R in Power Query

Power Query is one of the main important components in Power BI that is used for data cleaning and wrangling. Power Query is a comprehensive component for extracting data from different locations, clean the data and load it (ETL). The main language behind the scene of Power Query is M. In this module, you will see how we can use R scripts in Power query for storing data in local machine or other devices, creating loops, normalizing the data, and Machine Learning.

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

How to access the R editor and how to use it
How to store the dataset from Power Query in a local machine
How to access the R editor in Power query and how to run the R scripts
How to use R to apply a loop on a dataset/column
How to expand the regular expression language
How to access the R codes in Power query advanced editor

1.5: Predictive Analytics in Power BI

Some explanation on what predictive analytics is will be provided. The main algorithms for classification and regression will be introduced. The main concepts of some algorithms for classification and regression such as Decision tree, KNN, linear and non-linear regression will be explained.

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

What is predictive analytics and what algorithms we use for predictive analytics
Main concepts for the decision tree, SVM, regression, and KNN will be provided
How to use decision tree algorithms (with related R codes) for the aim of classification in Power Query will be explained
How to use regression algorithm for predicting a value in power Query will be shown
How to parametrize the algorithm in Power Query for future use will be explained

1.6: Descriptive Analytics in Power BI

In this module, a brief explanation of what is descriptive analytics, what is clustering, what is market basket analytics will be provided. Audience will learn

Basic concepts for clustering and market basket analytics
How to write R scripts and what function has been used
How to do Clustering in Power BI visualization and Power Query

1.7: Time series with R in Power BI

Forecasting is a popular and useful trend in many industries. Time series is an algorithm that has been used for forecasting the trend, pattern and future value for their sales, profit and so forth. In this module below item will be presented

What is Time series and what are the main concepts behind it
How to write R scripts for time series decomposition, forecasting using exponential smoothing and so forth.
How to do forecasting in Power BI report and Power Query

1.8: Pre-build Advanced Analytics Visualization

Microsoft provides lots of interesting advanced analytics chart in the marketplace for Power BI users. This charts able end user to use them for analytics without writing any R scripts.

How to access the Power BI advanced analytics visualization in Marketplace
What is decision tree visualization and how to use it
What is time series visualizations?
How to use clustering and correlation analytics visualization

1.9: Create Custom Visual with R and JSON Scripts

There is a possibility to expand the visualization in Power BI with creating custom visual. These visuals have some difference from what we have in section 1-3. These custom visuals can be shared with others easily without disclosing the code behind them. These visualizations can be put in a list of visual for other people in the company. In this section.

How to create custom visual with R
How to use the Power BI template for it
How to create a proper setting and so forth

In-Person Training;

https://radacad.com/events

Online Training;

https://radacad.com/events

Use the letter written for your boss to convince him/her to pay for your Power BI Training course

Check Schedule of upcoming events here

Check cancellation policies and rates here

What others say about the training and trainer

Kenny McMillan, Sports Physiologist / Data Analyst, Frankfurt, Germany:
I attended RADACADs “Advanced Analytics” course recently in Frankfurt in May 2017. Being a regular user of Power BI (with a science background ) the course was extremely helpful in showing me how to incorporate R data visualizations into Power BI dashboards and for introducing me to machine learning using the Microsoft ML Studio. Leila is an excellent and extremely knowledgeable instructor and explained complex data analytical concepts and methodologies in an easy-to-understand manner. I thoroughly recommend this course to anyone who wants to expand their data analytical skills and knowledge.

Martin Catherall (Microsoft Data Platform MVP):

As part of SQL Saturday Auckland 2016 I attended an “Analytics with Power BI and R.” pre-con with Leila. Leila took the class’s knowledge from rudimentary to competent in a day. We first looked at R, the language and the software. Once these skills were obtained we started to look at Power BI and the integration that it has with R. We worked through a few examples and Leila answered all of the class’s questions and offered to provide supplementary material for some of the more advanced questions. I left the class feeling that my R and Power BI knowledge was at a competent level and ready to dive into some of the more advanced material that Leila provided.

Who Attended RADACAD Training Courses

Cancellation:
Cancellation up to 5 weeks before the event: full refund minus administration fee ($50) and credit-card processing fees (if applicable).

Cancellation from 5 weeks to 2 weeks before the event: 50% cancellation charge, 50% refund

Transfer fee to another event date* (from 2 weeks to 1 day before the event): 40% of the standard price of the event to transfer

Transfer fee at the day of event*: 60% of the standard price of the event to transfer

*transfer can be done only once, and it can be only transferred to another date not later than 6 months from the original event.
No Show:
No fee will be refunded for no show.

Save

Time

13 (Tuesday) 8:00 am - 14 (Wednesday) 4:00 pm GMT

Location

Auckland TBD

Auckland, Auckland, New Zealand

Organizer

Leila Etaatileila@radacad.com

13aug - 14aug 138:00 amaug 14Power BI from Rookie to Rock Star - Module 1: Power BI for Data Analysts (Visualization) – 2 days course - Auckland Time Zone

Register Here

Course Title: Power BI from Rookie to Rock Star

Length:

From 1 to 9 days (Lecture + Labs): depends on the modules you enrol.

Delivery method:

In-Person or Online: Check the schedule of upcoming courses.

Type of training:

Public or private (contact us for more details)

The course is scheduled for Auckland’s time zone from 8:00 Am to 4:00 PM each day.

This course is delivered to thousands of people all around the world, check out only a few of the recommendations at the bottom of this page, and check some of our clients.

Instructor: Reza Rad

Power BI from Rookie to Rock Star

Module 1: Power BI for Data Analysts (2 days)
Module 2: Power BI for Data Wrangler and Transformer (2 days)
Module 3: Power BI for Data Modeler (2 days)
Module 4: Power BI for Architects (1 day)
Module 5: Power BI for Data Scientists (2 days)

Module 1: Power BI for Data Analysts (Visualization) – 2 days course

This training is designed for data analysts, who have the data modeled and ready for them to visualize. In this training, you will learn detailed visualization practices of Power BI.

In this two days training, you will learn all components of Power BI needed for building Power BI reports and dashboards. You will learn about components such as Get Data (Power Query), Modelling and DAX, and Visualization. You will also learn about the Power BI service (website), and components that are needed to share your reports with others.

The training continues with more focus on Visualization components such as different types of charts and visuals and scenario to use them. You will also learn about advanced visualization techniques such as designing mobile reports, changing the interactivity of visual, detailed learning of slicers and filters, creating parent-child reports, etc.

At the end of this training, you will be able to do all visualization requirements for Power BI and will understand all other components of Power BI and how these are all working together.

The training includes but not limited to topics below:

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 the basics of this product and introduce all components of Power BI (Power Query, Power Pivot, Power View, 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, and Power Q&A.

1.2: Getting Data and Transformation

Getting Data is the first experience of working with Power BI. You can connect to many data sources on-premises or on the cloud. In this section, you will learn how the Get data experience in Power BI is and how you can transform the data in a way to get it ready for modeling.

What is Power Query: Introduction to Data Mash-Up Engine of Power BI
Different versions of Power Query
Power Query Introduction
Query Editor
Transformation GUI
Get Started with Power Query: Movies Data Mash-Up
Power BI Get Data from Excel: Everything You Need to Know
What is the Role of Power Query in a Power BI Solution

1.3: Data Modelling and DAX

Data Modelling in Power BI is an in-memory-based technology. You will learn about the structure of modeling in Power BI, and you will learn the importance of relationships and their direction. You will also learn about calculations in Power BI and how to write them. DAX is Data Analytical eXpression language. DAX has a similar structure to excel functions, but it is different. In this module, you will learn DAX about DAX too.

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

Power BI xVelocity engine basics and concepts
Relationships in Power BI
Hierarchies and Formatting
Sorting by other columns
Date Table
Introduction to DAX
Calculated Columns, Measures, and Calculated Tables

1.4: Data Visualization

Data Visualization is the front end of any BI application; this is the user viewpoint of your system. It is critical to visualize measures, and dimensions effectively so the BI system could tell the story of the data. In this module, you will learn conceptual best practices of data visualizations which is valid through all data visualization tools. You will learn Power BI visualization skills. You will learn how to create effective charts, and dashboards using these tools as well as best practices for working with Power BI Desktop.

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

Power BI Desktop Visualization
Formatting Visuals in Power BI Desktop
Basic Charts and Visuals in Power BI
Sorting, Filtering, and categorization
Custom Visuals in Power BI Desktop
Maps and Geo-Spatial Visualization

1.5: Power BI Service

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 on 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;

Basic Sharing and using workspaces in Power BI web site
Dashboard vs. Report
Power Q&A
Mobile Dashboard Design
Row Level Security
Schedule Refresh vs. Other types of connections
Gateway’s Role in the Service

1.6: Visualization Basics

Visualization is an important part of any BI system. In Power BI, Visualization plays a critical part. In this section, you will learn about why visualization is important, with few basics of visualizations such as comparing stacked vs. clustered chart. You will also learn in this section about data exploration techniques such as drill down/up, using pages, etc.

Importance of Visualization
Basic Charts; Bar and Column Charts
Clustered vs. Stacked Charts
Q&A for Reports
Quick Measures in Power BI
Drill Down and Up using visuals and hierarchies
Pages

1.7: Slicing and Dicing

The importance of slicing and dicing data in Power BI is critical. Power BI is not a visualization tool only, but it is also a data exploration tool. There are several ways you can filter the data. In this section, you will learn the difference between filters and slicers. You also learn about different scopes of filtering, as well as filtering modes. For slicers, you will learn different types of slicers and some advanced features such as syncing slicers through different pages.

Filters
Scopes of Filters: Visual Level, Page Level, Report Level
Modes of Filtering: Basic, Advanced, Relative, Top N
Drill through Page Filter: Creating master-details page scenario in Power BI
Slicers
Types of Slicers; Date, Text, Number
Slicer Formatting
Syncing Slicer between Pages

1.8: Advanced Visualization in Power BI

Know that you know about visualizations and slicing and dicing, it is a good time to talk about some advanced techniques which will take your visualizations to the next level in Power BI. You will learn about techniques such as changing the interaction of visuals, report page tooltips, Bookmarks and dynamic visualizations in this section.

Report Page Tooltip
Controlling the interaction of Visuals in a page
Designing Power BI reports for Mobile
Grouping and Binning
Bookmark; saving the state of a page
Buttons; action items
Selection pane; visibility control in Power BI
Golden triangle; Bookmark, button, and selection pane
Colour theme or pallets in Power BI

1.9: Best Practice Scenarios of Using Visuals

It is a good time to learn about all built-in visuals in Power BI now. It is important to know which visual should be used in what scenario. You will also learn in this section about the pros and cons of each visual. You will learn specific features of the visual that can help to solve real-world scenarios. All the examples will be hands-on.

Line Chart; Trend Analysis
Combo Charts; Different Scales in one graph
Ribbon Chart; Ranking
Waterfall Chart; Cashflow
Scatter Chart; Storytelling with the data
Grouping charts: Pie, Donut chart, and Treemap charts
KPI visual
Gauge
Card Visual
Table and Matrix; showing the numbers with conditional formatting

1.10: Geo Location Visualization: Map Visuals

In Power BI, there are multiple ways of visualizing items on the map. In this section, you will learn about all the built-in ways of using map visuals in Power BI, the pros, and cons of each method and special considerations for some of the visuals.

Map Visual; Using Bing to find spots
Fine Tuning Address Details
Map Visual; Using Latitude and Longitude
Filled Map; Regions and Polygons
Data Category importance for the filled map
Shape Map; Having custom map visual
ArcGIS Map; Map visual which can do everything

1.11: Custom Visuals

In addition to the built-in list of Power BI visuals, you can leverage some of the third party visuals created by other companies called Custom Visuals. Creating custom visuals is a developer topic, which we won’t discuss in this training, but you will learn about how to use custom visuals. You will learn about the most useful custom visuals in Power BI through many demos.

Adding and using a custom visual
Infographic Designer
Tachometer Gauge
Map custom visuals
Certified custom visuals
Hierarchy Slicer
Play Axis
R Custom Visuals

Register Here

Why Power BI Training?

Common Myths about Power BI

Myth 1: Power BI is a self-service Excel tool, and isn’t suitable for Enterprise Solutions.

Myth 2: Power BI is easy to use, and doesn’t require a training course.

Myth 3: Power BI is only for Microsoft based environments and platforms.

Myth 4: Power BI is not a powerful and fully functional BI tool, and cannot be compared with other tools in the market.

In addition, there is always the possibility to use this as a hybrid approach and save lots of time and money along with great features that are only available in this product.

In-Person Training;

https://radacad.com/events

Online Training;

https://radacad.com/events

Use the letter written for your boss to convince him/her to pay for your Power BI Training course

Check Schedule of upcoming events here

Check cancellation policies and rates here

What others say about the training and trainer

Daniel R Tuma, Senior Systems Analyst at Cleveland Metro Schools, Ohio, USA

I spent probably about two weeks looking for a good Microsoft Power BI class that would cover all of the aspects of the program. I wanted to walk away from the class being able to apply what I learned immediately. Most training companies that I looked into were in a state of flux with Power BI mostly due to the transitions that Power BI itself was going through. Then I stumbled on the RADACAD web site. Reza Rad touted a course that he taught named “Power BI, From Rookie to Rock star.” If the class was indeed an A to Z course, then it was exactly what I was looking for. The class outline seemed to include every topic on my checkoff list plus much more. I decided to give Reza a try.
Reza completely lived up to his hype. He took us through a natural progression of the software, using example after example of how to complete a task. We went through real world scenarios, a bare minimum of two scenarios for each minor topic. I was completely impressed with his Power BI knowledge, understanding and abilities. Any question we came to Reza with was answered completely and with even more examples.
After the class, my goal of immediately applying what I learned was attained. Right away I was able to successfully pull and massage data, create useful reports and post them to dashboards.
I would recommend Radacad Power BI Training without hesitation.

Jeffrey Weir; Independent Consultant, Wellington, New Zealand

I learned a lot from this course: it gave a great overview of what’s possible both right from the UI, and what more awaits if you lift the hood and pimp the engine. It’s incredible to see just how much PowerBI and PowerQuery radically simplify what I would otherwise have to do with many, many lines of complicated VBA code. And Reza is a masterful user of this tool.

Note that Reza covers a lot of ground in this course, and it is pretty fast paced. While you can take a laptop and follow along as Reza takes PowerBI/Powerquery through its paces, for the one-day course my recommendation would be to keep that laptop closed, and simply sit back and watch Reza in action, so you can fully concentrate on just how simple this tool is to use in the right hands as well as think about how you might use the tool to your own ends and ask questions along those lines. You can always purchase the video course (if it’s not already included in your course) and step through the material again at your own pace.

Rob Wilby; Independent Consultant, UK

I must say your “Power BI Essentials” course has been the most comprehensive Power BI course I have found to date and seeing how you work with data especially the little tricks naturally introduced at just the right moments has made this course a pleasure to take.

Martin Catherall – Data Platform MVP, PASS Regional Mentor

I attended Reza’s Power BI pre-con “From Rookie to Rock star” at SQL Saturday Brisbane in May 2016. I was a complete Power BI novice, having only previously accomplished a few very basic things with Power BI. Reza took the group through all the components that make up environment. He explained how they had evolved and took the group through walk-throughs of each one. Reza was great an answering questions from the audience at the event and going into extra detail if necessary. All-in all, I would say that I’m now a very confident Power BI user after attending Reza’s pre-con.

Dan Cheshire, Senior Project Manager Air New Zealand

Reza does not just know Power BI like the back of his hand, he is the most commercially aware BI person I know. He understands that companies work in the real world and that data isn’t always clean and needs manipulation for it to work and be useful. When Reza worked on our project, nothing phased or flustered him, he always came up with solutions for problems that seemed to me as insurmountable. Can’t recommend him enough, invest in Reza as he will not only save you a whole heap of time, but he comes up with long lasting and very powerful Power BI solutions for your business.

Sonia Buckley, Data Analyst at Zoom2u, Sydney, Australia

We have started to use Microsoft Power BI and whilst Microsoft tutorials are helpful, if you are not used to DAX then it is very difficult to get your head around and there is little other resources that don’t cost an arm and a leg. I had a call with Reza who made my life so much easier in just under an hour! Any time spent speaking to Reza will be well worth it – I have saved hours of trying to get my head around our dashboards by getting some very useful tips and explanations on why things are done the DAX way! Not only that but he is very patient and straight forward. Highly recommended!

R. Kemp, Canada

The course was an excellent investment overall, it exceed my expectations. It was well paced and presented. The instructor, Reza Rad, was excellent and was able to answer all my questions and explain complex idea in a manner that was easy to understand and follow. I had been using Power BI Desktop for a number of months prior to taking this course, but wish I had attended it sooner! The course structure of 1 day of overall Power BI and followed by 4 days of more intensive instruction on the various parts of Power BI allowed for a basic understanding of the whole, and then more comprehensive learning. The live-on-line experience worked well technically and allowed for questions and problem-solving with the instructor. I learned a lot about Power BI and this course gave me a great foundation for using Power BI to clean, model, design, and share reports using a variety of visualizations that will provide business intelligence to my company. I would recommend this course to anyone wanting to learn Power BI either as a starting point or even after you have used the tool to deepen your understanding and build your skill-set.

Who Attended RADACAD Training Courses

Register Here

Cancellation:
Cancellation up to 5 weeks before the event: full refund minus administration fee ($50) and credit-card processing fees (if applicable).

Cancellation from 5 weeks to 2 weeks before the event: 50% cancellation charge, 50% refund

Transfer fee to another event date* (from 2 weeks to 1 day before the event): 40% of the standard price of the event to transfer

Transfer fee at the day of event*: 60% of the standard price of the event to transfer

*transfer can be done only once, and it can be only transferred to another date not later than 6 months from the original event.
No Show:
No fee will be refunded for no show.

Save

Time

13 (Tuesday) 8:00 am - 14 (Wednesday) 4:00 pm GMT

Location

Auckland TBD

Auckland, Auckland, New Zealand

Organizer

Reza Radreza@radacad.com

Learn More

24sep - 25sep 248:00 amsep 25Power BI from Rookie to Rock Star - Module 2: Power BI for Data Wrangler/Transformer (Data Transformation) – 2 days course - Auckland Time Zone

Register Here

Course Title: Power BI from Rookie to Rock Star

Length:

From 1 to 9 days (Lecture + Labs): depends on the modules you enrol.

Delivery method:

In-Person or Online: Check the schedule of upcoming courses.

Type of training:

Public or private (contact us for more details)

The course is scheduled for Auckland’s time zone from 8:00 Am to 4:00 PM each day.

This course is delivered to thousands of people all around the world, check out only a few of the recommendations at the bottom of this page, and check some of our clients.

Instructor: Reza Rad

Power BI from Rookie to Rock Star

Module 1: Power BI for Data Analysts (2 days)
Module 2: Power BI for Data Wrangler and Transformer (2 days)
Module 3: Power BI for Data Modeler (2 days)
Module 4: Power BI for Architects (1 day)
Module 5: Power BI for Data Scientists (2 days)

Module 2: Power BI for Data Wrangler/Transformer (Data Transformation) – 2 days course

The training includes but not limited to topics below:

2.1: Get Data

Introduction to Power Query
Query Editor
Get Data from Web
Basic Transformations
Get Data from Excel
Use First Row As Headers / Use Headers as First Row
Get Data from SQL Server

2.2: Data Types and Data Structures

Base data structures in Power Query
Get Data from JSON
Transforming Table, Record, and List
Data Types in Power Query
Query Operations
Enable Load; Performance Boost
Query Operations; Duplicate, and Reference

2.3: Combine Queries

Dimensional Modelling; Designing the data model
Append, creating a single big query of the same structure
Merge; Joining queries when the structure is different
Join types in Merge
Tips to consider after Merge or Append

2.4: Better Power Query Editor Experience

Groups; Folders in Query Editor
Steps Operations
Splitting query steps
Moving steps up or down
Add as new query / Drill Down
Be Careful of Actions; Undo!

2.5: Reducing Number of Rows; Filtering

Row Operations; Removing rows
Row Operations; Keeping rows
Remove/Keep Errors
Remove/Keep Duplicates
Using Remove/Keep combination for troubleshooting report
Filtering based on Individual values
The dilemma of the basic filtering
Advanced Filtering
Sorting

2.6: Column Operations

Column Operations
Choosing Columns
Removing Columns
Data Type Change
Locale consideration for the data type
Replace Values
Fill Down/Up; Very Useful for Excel

2.7: Table Transformations

Group By; Changing the granularity of the data table
Group by Advanced
Scripting and Group by; First and Last item in each group
Transpose; rows to columns and reverse
Pivot; changing the name-value structure to columns
Unpivot; changing the budget column structure to rows

2.8: Text Transformations

Split Column by Delimiter
Split Column by number of Characters
Split into rows instead of columns
Merge (Concatenate)
Format
The difference between Clean and Trim
Parse (XML or JSON)
Extract part of the text

2.9: Numeric Transformations

Standard transformations; Divide, Integer-divide, Multiply, Add etc.
Scientific transformations; logarithm, power square, etc.
Statistics transformations;
Rounding
Information functions; Is Even, Is Odd, and Sign.
Dealing with faults in Numeric calculations

2.10: Date and Time Transformations

Date Transformations (Year, Month, Quarter, Week, etc.)
Extending Fiscal Date Column
Time Transformations (Hour, Minute, Second, etc.)
Adding Time/Date banding
Duration Transformation and Data Type
Age Calculation
Local Date or Time
Time zone consideration for Power BI

2.11: Structured Column Transformations

What is a Structured Column?
Expand
Aggregate
Expand and Aggregate: Performance Consideration

2.12: Add Column Transformations

Add Column vs. Transform?
Add Column with a Transformation
Index Column: Row Number
Conditional Column
Add Column by Example; When you don’t know which transformation to use
Add Custom Column: Generic

2.13: Functions and Parameters; Dynamic Power Query

Defining Parameters
Using Parameters in an existing query
Advanced GUI for parameters
Creating Function from a query
Invoking the sample function
Add Column Transform: Invoke Custom Function
When the advanced GUI does not exist

2.14: Power Query Formula Language: M

What is M? and the importance of learning M
M Syntax
End of the line
Variable Names
Special Characters
Escape Character
Step by Step Coding
Literals
Function Call
Comments
A real-world example

2.15: Working with Data Structures in M

Primitive Value
List
Record
Table
Function
Navigating through List and List functions
Navigating through Record and Record functions
Navigating through Table and table functions
Concatenating lists and records

2.16: Advanced M Scripting

#Shared Keyword; function library of Power Query
Parameters in the code
Custom Functions through scripting
Error Handling in Power Query
Generators in Power Query: Implementing Loop Structure
EACH: singleton function
Sample Custom Function: Day Number of Year Custom Function

2.17: Performance Tips and Tricks for Power Query

Enable Load; Simple, but Efficient
Reducing Number of Columns
Query Folding
Grouping and Aggregation; Performance Consideration
Merge; Before and After, things to Consider

2.18: Error Handling

Keep/Remove Errors; Troubleshooting report
Count Rows
Reference/Duplicate
Replace Errors
Data Type considerations

2.19: Use Cases

Date Dimension with Power Query; building the base table
Adding Fiscal columns to the Date dimension
Getting public holidays live and merging to the date dimension
Looping through files in a folder with Power Query

Register Here

Why Power BI Training?

Common Myths about Power BI

Myth 1: Power BI is a self-service Excel tool, and isn’t suitable for Enterprise Solutions.

Myth 2: Power BI is easy to use, and doesn’t require a training course.

Myth 3: Power BI is only for Microsoft based environments and platforms.

Myth 4: Power BI is not a powerful and fully functional BI tool, and cannot be compared with other tools in the market.

In addition, there is always the possibility to use this as a hybrid approach and save lots of time and money along with great features that are only available in this product.

In-Person Training;

https://radacad.com/events

Online Training;

https://radacad.com/events

Use the letter written for your boss to convince him/her to pay for your Power BI Training course

Check Schedule of upcoming events here

Check cancellation policies and rates here

What others say about the training and trainer

Daniel R Tuma, Senior Systems Analyst at Cleveland Metro Schools, Ohio, USA

I spent probably about two weeks looking for a good Microsoft Power BI class that would cover all of the aspects of the program. I wanted to walk away from the class being able to apply what I learned immediately. Most training companies that I looked into were in a state of flux with Power BI mostly due to the transitions that Power BI itself was going through. Then I stumbled on the RADACAD web site. Reza Rad touted a course that he taught named “Power BI, From Rookie to Rock star.” If the class was indeed an A to Z course, then it was exactly what I was looking for. The class outline seemed to include every topic on my checkoff list plus much more. I decided to give Reza a try.
Reza completely lived up to his hype. He took us through a natural progression of the software, using example after example of how to complete a task. We went through real world scenarios, a bare minimum of two scenarios for each minor topic. I was completely impressed with his Power BI knowledge, understanding and abilities. Any question we came to Reza with was answered completely and with even more examples.
After the class, my goal of immediately applying what I learned was attained. Right away I was able to successfully pull and massage data, create useful reports and post them to dashboards.
I would recommend Radacad Power BI Training without hesitation.

Jeffrey Weir; Independent Consultant, Wellington, New Zealand

I learned a lot from this course: it gave a great overview of what’s possible both right from the UI, and what more awaits if you lift the hood and pimp the engine. It’s incredible to see just how much PowerBI and PowerQuery radically simplify what I would otherwise have to do with many, many lines of complicated VBA code. And Reza is a masterful user of this tool.

Note that Reza covers a lot of ground in this course, and it is pretty fast paced. While you can take a laptop and follow along as Reza takes PowerBI/Powerquery through its paces, for the one-day course my recommendation would be to keep that laptop closed, and simply sit back and watch Reza in action, so you can fully concentrate on just how simple this tool is to use in the right hands as well as think about how you might use the tool to your own ends and ask questions along those lines. You can always purchase the video course (if it’s not already included in your course) and step through the material again at your own pace.

Rob Wilby; Independent Consultant, UK

I must say your “Power BI Essentials” course has been the most comprehensive Power BI course I have found to date and seeing how you work with data especially the little tricks naturally introduced at just the right moments has made this course a pleasure to take.

Martin Catherall – Data Platform MVP, PASS Regional Mentor

I attended Reza’s Power BI pre-con “From Rookie to Rock star” at SQL Saturday Brisbane in May 2016. I was a complete Power BI novice, having only previously accomplished a few very basic things with Power BI. Reza took the group through all the components that make up environment. He explained how they had evolved and took the group through walk-throughs of each one. Reza was great an answering questions from the audience at the event and going into extra detail if necessary. All-in all, I would say that I’m now a very confident Power BI user after attending Reza’s pre-con.

Dan Cheshire, Senior Project Manager Air New Zealand

Reza does not just know Power BI like the back of his hand, he is the most commercially aware BI person I know. He understands that companies work in the real world and that data isn’t always clean and needs manipulation for it to work and be useful. When Reza worked on our project, nothing phased or flustered him, he always came up with solutions for problems that seemed to me as insurmountable. Can’t recommend him enough, invest in Reza as he will not only save you a whole heap of time, but he comes up with long lasting and very powerful Power BI solutions for your business.

Sonia Buckley, Data Analyst at Zoom2u, Sydney, Australia

We have started to use Microsoft Power BI and whilst Microsoft tutorials are helpful, if you are not used to DAX then it is very difficult to get your head around and there is little other resources that don’t cost an arm and a leg. I had a call with Reza who made my life so much easier in just under an hour! Any time spent speaking to Reza will be well worth it – I have saved hours of trying to get my head around our dashboards by getting some very useful tips and explanations on why things are done the DAX way! Not only that but he is very patient and straight forward. Highly recommended!

R. Kemp, Canada

The course was an excellent investment overall, it exceed my expectations. It was well paced and presented. The instructor, Reza Rad, was excellent and was able to answer all my questions and explain complex idea in a manner that was easy to understand and follow. I had been using Power BI Desktop for a number of months prior to taking this course, but wish I had attended it sooner! The course structure of 1 day of overall Power BI and followed by 4 days of more intensive instruction on the various parts of Power BI allowed for a basic understanding of the whole, and then more comprehensive learning. The live-on-line experience worked well technically and allowed for questions and problem-solving with the instructor. I learned a lot about Power BI and this course gave me a great foundation for using Power BI to clean, model, design, and share reports using a variety of visualizations that will provide business intelligence to my company. I would recommend this course to anyone wanting to learn Power BI either as a starting point or even after you have used the tool to deepen your understanding and build your skill-set.

Who Attended RADACAD Training Courses

Register Here

Cancellation:
Cancellation up to 5 weeks before the event: full refund minus administration fee ($50) and credit-card processing fees (if applicable).

Cancellation from 5 weeks to 2 weeks before the event: 50% cancellation charge, 50% refund

Transfer fee to another event date* (from 2 weeks to 1 day before the event): 40% of the standard price of the event to transfer

Transfer fee at the day of event*: 60% of the standard price of the event to transfer

*transfer can be done only once, and it can be only transferred to another date not later than 6 months from the original event.
No Show:
No fee will be refunded for no show.

Save

Time

24 (Tuesday) 8:00 am - 25 (Wednesday) 4:00 pm GMT

Location

Auckland TBD

Organizer

Reza Radreza@radacad.com

Learn More

24sep - 25sep 248:00 amsep 25Data Science Training - Module 2: Data Science with Microsoft Cloud – 2 Days Auckland Time Zone

Register Here

Course Title: Data Science and Advanced Analytics with Microsoft Technologies

Length:

From 1 to 7 days (Lecture + Labs): depends on the modules you enroll.

Delivery method:

In-Person or Online: Check the schedule of upcoming courses.

Type of training:

Public or private (contact us for more details)

The course is scheduled for Auckland’s time zone from 8:00 Am to 4:00 PM each day.

This course is delivered to thousands of people all around the world, check out only a few of the recommendations at the bottom of this page, and check some of our clients.

Instructor: Dr. Leila Etaati

Advanced Analytics with Microsoft Technologies

Module 1: Power BI for Data Scientists (2 days)
Module 2: Data Science with Microsoft Cloud (2-days)
Module 3: Advanced Data Science with Microsoft Services (2-days)
Module 4: AI and Cognitive Services in Applications (1-day)

Module 2: Data Science with Microsoft Cloud – 2 days course

The training includes but not limited to topics below:

2.1: Azure Machine Learning (ML) Studio

In this section, you will learn some basic of machine learning and how it works. Then some introduction to Azure ML Studio will be provided.

Import data: The main component for importing data from local PC, how to import data from another workspace, how to import data from HTML website, how to import data from cloud such as Azure SQL DB.
Data Cleaning: data cleaning is the main process that we should do before any machine learning process. I will explain the available component in Azure ML. How to clean missing values, remove duplicate data, select column, clip value (remove outliers), group data into bins, and create an indicator for data. You will learn how to normalize the data, how to use SQL Statement for data transformation, how to use enter data manually, how to edit the data type, change the column name with edit metadata component, how to join data from different data resource , how to increase the number of low incidence in a dataset which unbalanced.
Feature Selection Data Sampling: the process of feature selection will be explained, how to split data, how to partition data using a sampling approach, how to create different folds for the aim of cross-validation.
Models: a bit talk about the available models in Azure mL for predictive, descriptive, prescriptive and anomaly detection. An example of a prediction of a group, a value, clustering data and anomaly detection will be shown. For each scenario, an example will be presented; different algorithms will apply to a problem. The main concepts of k-mean, how to use elbow chart to identify the number of the cluster will be discussed, the PCA chart will be explained. The trained model for recommendation “match box recommender” will be explained through a scenario. The main concepts of collaborative filtering and content-based filtering and hybrid approach for recommendation will be discussed.
Training and Scoring models: how to choose algorithms and how to train model and test model, what is cross-validation, how to do cross-validation to apply a model to different folds of data, how to check the different values for each parameter and see the related accuracy to that.
Evaluate: how to evaluate a classification problem concepts of Accuracy, Recall, Precision, AUC will be discussed, the evaluation criteria for regression algorithm MAE, RMSE and so on will be shown. How to evaluate and see the result of more than three algorithms on one dataset will be shown. Using different evaluate the model, enter data manually component and add row component.
Publish to Web: the process of creating a web service from a model will be discussed, how to check it in Excel will be shown, also how to use it in Stream Analytics as a function for data will be shown.
Sharing workspace, create projects: the process of how to share the workspace with others will be discussed, how to create a project for each experiment, how to create a trained model component for reuse, and a data transformed dataset, how to export datasets to CSV, and other formats will be shown.
Azure ML model in Power BI: Create a model in Azure ML Studio and use it in Power BI
Azure ML Model in IoT: the process of how to create a model in Azure ML model studio and apply it on streamed data.

2.2: Data science Virtual Machine

How to set it up
- Environment needs
- What parameter needs to be set up
What software and tools can be used
- visual studio and how to access R and Python
- Azure ML workbench
- SQL Server and Power BI
Deep learning introduction
Deep learning tools such as Tensor flow and so forth.
- Tensorflow
- Weka

2.3: Azure Data Lake Analytics

How to set up Azure Data Lake Store gen1 and Azure Data Lake Analytics
- Th main process of how to set them up will be explained
- How to access Azure Data Lake Analytics via visual studio also will be explained
How to use an existing sample of U-SQL
- An introduction into USQL
- How to run USQL in the cloud and how to run it
How to write R codes inside USQL
- How embed the R or Python code
- How to pass parameters and access the data
What is the best practice to create a machine learning project in data Lake
- How to create a model
- Store model
- And use the model for production

2.4: Azure Data Bricks

What is data bricks and how to set it up
The environment of data bricks and explain how they work
How to able to write R, Python, Scala, and SQL at the same time
Visualization of Databricks
Workspace and clusters
How to get information from Azure Data Lake store
How to get data from event Hub
What is notebook
How to pass data from one cell to other
How to use Databricks for a machine learning scenario storage model in Azure Data lake and show the result in Power BI

In-Person Training;

https://radacad.com/events

Online Training;

https://radacad.com/events

Use the letter written for your boss to convince him/her to pay for your Power BI Training course

Check Schedule of upcoming events here

Check cancellation policies and rates here

What others say about the training and trainer

Kenny McMillan, Sports Physiologist / Data Analyst, Frankfurt, Germany:
I attended RADACADs “Advanced Analytics” course recently in Frankfurt in May 2017. Being a regular user of Power BI (with a science background ) the course was extremely helpful in showing me how to incorporate R data visualizations into Power BI dashboards and for introducing me to machine learning using the Microsoft ML Studio. Leila is an excellent and extremely knowledgeable instructor and explained complex data analytical concepts and methodologies in an easy-to-understand manner. I thoroughly recommend this course to anyone who wants to expand their data analytical skills and knowledge.

Martin Catherall (Microsoft Data Platform MVP):

As part of SQL Saturday Auckland 2016 I attended an “Analytics with Power BI and R.” pre-con with Leila. Leila took the class’s knowledge from rudimentary to competent in a day. We first looked at R, the language and the software. Once these skills were obtained we started to look at Power BI and the integration that it has with R. We worked through a few examples and Leila answered all of the class’s questions and offered to provide supplementary material for some of the more advanced questions. I left the class feeling that my R and Power BI knowledge was at a competent level and ready to dive into some of the more advanced material that Leila provided.

Who Attended RADACAD Training Courses

Cancellation:
Cancellation up to 5 weeks before the event: full refund minus administration fee ($50) and credit-card processing fees (if applicable).

Cancellation from 5 weeks to 2 weeks before the event: 50% cancellation charge, 50% refund

Transfer fee to another event date* (from 2 weeks to 1 day before the event): 40% of the standard price of the event to transfer

Transfer fee at the day of event*: 60% of the standard price of the event to transfer

*transfer can be done only once, and it can be only transferred to another date not later than 6 months from the original event.
No Show:
No fee will be refunded for no show.

Save

Time

24 (Tuesday) 8:00 am - 25 (Wednesday) 4:00 pm GMT

Location

Auckland TBD

Auckland, Auckland, New Zealand

Organizer

Leila Etaatileila@radacad.com

Learn More

22oct - 23oct 228:00 amoct 23Data Science Training - Module 3: Advanced Data Science with Microsoft Services – 2 Days Course Auckland Time Zone

Register Here

Course Title: Data Science and Advanced Analytics with Microsoft Technologies

Length:

From 1 to 7 days (Lecture + Labs): depends on the modules you enroll.

Delivery method:

In Person or Online: Check the schedule of upcoming courses.

Type of training:

Public or private (contact us for more details)

The course is scheduled for Auckland’s time zone from 8:00 Am to 4:00 PM each day.

This course is delivered to thousands of people all around the world, check out only a few of the recommendations at the bottom of this page, and check some of our clients.

Instructor: Dr. Leila Etaati

Advanced Analytics with Microsoft Technologies

Module 1: Power BI for Data Scientists (2 days)
Module 2: Data Science with Microsoft Cloud (2-days)
Module 3: Advanced Data Science with Microsoft Services (2-days)
Module 4: AI and Cognitive Services in Applications (1-day)

Module 3: Advanced Data Science with Microsoft Services – 2 days course

The training includes but not limited to topics below:

3.1: Machine Learning Basics

The main concepts, life cycle and best practice of doing machine learning with Microsoft product will be explained.

The main Predictive, descriptive and Prescriptive analysis will be explained
What are the main stages of machine learning cycle will be illustrated
- Business understanding
- Data cleaning and feature selection
- Model Selection
- Data training and testing
- Evaluating measures
- Writing codes

3.2: Predictive Analytics

What is classification and how to evaluate a classification result using confusion Matrix
Decision Tree, Decision Forest, and Boosted decision tree
SVM and KNN
How to do classification using decision tree in SQL Server 2016
How to classify by decision forest in Power BI
The main code for SVM and KNN and how to compare the results by writing R codes

3.3: Descriptive Analytics

The main concepts for clustering and k-mean clustering will be explained. Also, the process of identifying the number of clusters will be explained
The main process for text mining for the aim of sentiment analytics, keyword extraction, and language detection
How to do clustering in Power BI and how to use Power BI visual to analysis cluster
What is market basket analysis and what is support, confidence and lift measure
How to do Market basket analysis with R and rules package and how to show the result in Power BI visualization tools
Text mining concepts and main concepts

3.4: Forecasting

What is the forecasting
How to decompose time series data
What is Exponential smoothing and how to do it in RStudio and Power BI
What is ARIMA and how to do it in Power BI

In-Person Training;

https://radacad.com/events

Online Training;

https://radacad.com/events

Use the letter written for your boss to convince him/her to pay for your Power BI Training course

Check Schedule of upcoming events here

Check cancellation policies and rates here

What others say about the training and trainer

Kenny McMillan, Sports Physiologist / Data Analyst, Frankfurt, Germany:
I attended RADACADs “Advanced Analytics” course recently in Frankfurt in May 2017. Being a regular user of Power BI (with a science background ) the course was extremely helpful in showing me how to incorporate R data visualizations into Power BI dashboards and for introducing me to machine learning using the Microsoft ML Studio. Leila is an excellent and extremely knowledgeable instructor and explained complex data analytical concepts and methodologies in an easy-to-understand manner. I thoroughly recommend this course to anyone who wants to expand their data analytical skills and knowledge.

Martin Catherall (Microsoft Data Platform MVP):

As part of SQL Saturday Auckland 2016 I attended an “Analytics with Power BI and R.” pre-con with Leila. Leila took the class’s knowledge from rudimentary to competent in a day. We first looked at R, the language and the software. Once these skills were obtained we started to look at Power BI and the integration that it has with R. We worked through a few examples and Leila answered all of the class’s questions and offered to provide supplementary material for some of the more advanced questions. I left the class feeling that my R and Power BI knowledge was at a competent level and ready to dive into some of the more advanced material that Leila provided.

Who Attended RADACAD Training Courses

Cancellation:
Cancellation up to 5 weeks before the event: full refund minus administration fee ($50) and credit-card processing fees (if applicable).

Cancellation from 5 weeks to 2 weeks before the event: 50% cancellation charge, 50% refund

Transfer fee to another event date* (from 2 weeks to 1 day before the event): 40% of the standard price of the event to transfer

Transfer fee at the day of event*: 60% of the standard price of the event to transfer

*transfer can be done only once, and it can be only transferred to another date not later than 6 months from the original event.
No Show:
No fee will be refunded for no show.

Save

Time

22 (Tuesday) 8:00 am - 23 (Wednesday) 4:00 pm GMT

Location

Auckland TBD

Auckland, Auckland, New Zealand

Organizer

Leila Etaatileila@radacad.com

Learn More

22oct - 23oct 228:00 amoct 23Power BI from Rookie to Rock Star - Module 3: Power BI for Data Modeler (Data Modelling and DAX) – 2 days course Auckland Time Zone

Register Here

Course Title: Power BI from Rookie to Rock Star

Length:

From 1 to 9 days (Lecture + Labs): depends on the modules you enrol.

Delivery method:

In-Person or Online: Check the schedule of upcoming courses.

Type of training:

Public or private (contact us for more details)

The course is scheduled for Auckland’s time zone from 8:00 Am to 4:00 PM each day.

This course is delivered to thousands of people all around the world, check out only a few of the recommendations at the bottom of this page, and check some of our clients.

Instructor: Reza Rad

Power BI from Rookie to Rock Star

Module 1: Power BI for Data Analysts (2 days)
Module 2: Power BI for Data Wrangler and Transformer (2 days)
Module 3: Power BI for Data Modeler (2 days)
Module 4: Power BI for Architects (1 day)
Module 5: Power BI for Data Scientists (2 days)

Module 3: Power BI for Data Modeler (Data Modelling and DAX) – 2 days course

The training includes but not limited to topics below:

3.1: Power BI Modelling 101

Basics of Modelling in Power BI
The step before this: Data Preparation
Relationships in Power BI; Filter propagation
Direction of Relationship
Be Careful of both directional relationship
Active or In-active relationships
Relationship based on multiple Columns
Role Playing Dimension
Formatting
Hide/Unhide Columns
Hierarchy Definition in Power BI
Sort by Column

3.2: Introduction to DAX

Syntax of DAX
Naming in DAX
Operators and Operands
Logical Operations
Data Types in Power BI Model
Overview of Functions in DAX
Variables
DAX or M? When to use Which?

3.3: Calculations in Power BI

Calculated Column; Row by Row
Measure; Single Output
Calculated Table; A derived table
Calculated Column? Maybe a good candidate for Power Query transformation
Measures are Dynamic

3.4: Aggregation and Iterator Functions

Aggregation Functions
Implicit Measures vs. Explicit Measures
Sum of an Expression: SumX
Iterator Functions
Difference between SUM and SUMX

3.5: Filter Functions

ALL
Filter Functions to be used inside other functions
Examples of using ALL function
ALL and SUMX; Percentage Calculation
AllExcept
Filter Function: Custom Filter
Values/Distinct; getting a unique list of values

3.6: Evaluation Contexts and Conditional Sum

Row Context
Filter Context
Exception for Row Context
Exception for Filter Context
Calculate Function
Conditional Sum; Three ways of Implementing; pros and Cons
Variables in DAX and using them for debugging

3.7: Relationship Functions

Related: Many to one
RelatedTable: Sub table that can be used as a filter
CrossFilter: Changing Direction of relationship
UseRelationship: using an inactive relationship
TreatAS function

3.8: Time Intelligence Functions

Choosing the Date Table: Built-in or Customized Date Table
Mark as Date Table
Year to Date, Quarter to Date
Fiscal Year to Date
Same Period Last Year
Year over Year Comparison
ParallelPeriod vs SamePeriodLastYear vs DateAdd
Running Total
Rolling 12 Month Sales
Average 12 Month Sales
Rolling 6 Months
Flexible time banding
Time zone consideration in Power BI

3.9: Dynamic DAX: Parameters

Numeric Parameter Definition through GUI
GenerateSeries DAX function
SelectedValue DAX function
Sample Scenario: Customer Retention with Dax and Power BI
Other Types of Parameters? Parameter Table
SWITCH
Sample Scenario: Selection of Measures in a table dynamically

3.10: Parent-Child Functions

Organizational Hierarchy or Chart of Accounts: unknown levels
Path function
PathLength: getting the number of levels
PathItem: finding a specific level
PathItemReverse
PathContains: Security Pattern
LookupValue: To get the other related fields

3.11: Best Practices Tips and Tricks

Modelling Best Practices
Understanding when to switch between Power Query and DAX
Considerations for very large tables
A tool that helps: Power BI Helper

Register Here

Why Power BI Training?

Common Myths about Power BI

Myth 1: Power BI is a self-service Excel tool, and isn’t suitable for Enterprise Solutions.

Myth 2: Power BI is easy to use, and doesn’t require a training course.

Myth 3: Power BI is only for Microsoft based environments and platforms.

Myth 4: Power BI is not a powerful and fully functional BI tool, and cannot be compared with other tools in the market.

In addition, there is always the possibility to use this as a hybrid approach and save lots of time and money along with great features that are only available in this product.

In-Person Training;

https://radacad.com/events

Online Training;

https://radacad.com/events

Use the letter written for your boss to convince him/her to pay for your Power BI Training course

Check Schedule of upcoming events here

Check cancellation policies and rates here

What others say about the training and trainer

Daniel R Tuma, Senior Systems Analyst at Cleveland Metro Schools, Ohio, USA

I spent probably about two weeks looking for a good Microsoft Power BI class that would cover all of the aspects of the program. I wanted to walk away from the class being able to apply what I learned immediately. Most training companies that I looked into were in a state of flux with Power BI mostly due to the transitions that Power BI itself was going through. Then I stumbled on the RADACAD web site. Reza Rad touted a course that he taught named “Power BI, From Rookie to Rock star.” If the class was indeed an A to Z course, then it was exactly what I was looking for. The class outline seemed to include every topic on my checkoff list plus much more. I decided to give Reza a try.
Reza completely lived up to his hype. He took us through a natural progression of the software, using example after example of how to complete a task. We went through real world scenarios, a bare minimum of two scenarios for each minor topic. I was completely impressed with his Power BI knowledge, understanding and abilities. Any question we came to Reza with was answered completely and with even more examples.
After the class, my goal of immediately applying what I learned was attained. Right away I was able to successfully pull and massage data, create useful reports and post them to dashboards.
I would recommend Radacad Power BI Training without hesitation.

Jeffrey Weir; Independent Consultant, Wellington, New Zealand

I learned a lot from this course: it gave a great overview of what’s possible both right from the UI, and what more awaits if you lift the hood and pimp the engine. It’s incredible to see just how much PowerBI and PowerQuery radically simplify what I would otherwise have to do with many, many lines of complicated VBA code. And Reza is a masterful user of this tool.

Note that Reza covers a lot of ground in this course, and it is pretty fast paced. While you can take a laptop and follow along as Reza takes PowerBI/Powerquery through its paces, for the one-day course my recommendation would be to keep that laptop closed, and simply sit back and watch Reza in action, so you can fully concentrate on just how simple this tool is to use in the right hands as well as think about how you might use the tool to your own ends and ask questions along those lines. You can always purchase the video course (if it’s not already included in your course) and step through the material again at your own pace.

Rob Wilby; Independent Consultant, UK

I must say your “Power BI Essentials” course has been the most comprehensive Power BI course I have found to date and seeing how you work with data especially the little tricks naturally introduced at just the right moments has made this course a pleasure to take.

Martin Catherall – Data Platform MVP, PASS Regional Mentor

I attended Reza’s Power BI pre-con “From Rookie to Rock star” at SQL Saturday Brisbane in May 2016. I was a complete Power BI novice, having only previously accomplished a few very basic things with Power BI. Reza took the group through all the components that make up environment. He explained how they had evolved and took the group through walk-throughs of each one. Reza was great an answering questions from the audience at the event and going into extra detail if necessary. All-in all, I would say that I’m now a very confident Power BI user after attending Reza’s pre-con.

Dan Cheshire, Senior Project Manager Air New Zealand

Reza does not just know Power BI like the back of his hand, he is the most commercially aware BI person I know. He understands that companies work in the real world and that data isn’t always clean and needs manipulation for it to work and be useful. When Reza worked on our project, nothing phased or flustered him, he always came up with solutions for problems that seemed to me as insurmountable. Can’t recommend him enough, invest in Reza as he will not only save you a whole heap of time, but he comes up with long lasting and very powerful Power BI solutions for your business.

Sonia Buckley, Data Analyst at Zoom2u, Sydney, Australia

We have started to use Microsoft Power BI and whilst Microsoft tutorials are helpful, if you are not used to DAX then it is very difficult to get your head around and there is little other resources that don’t cost an arm and a leg. I had a call with Reza who made my life so much easier in just under an hour! Any time spent speaking to Reza will be well worth it – I have saved hours of trying to get my head around our dashboards by getting some very useful tips and explanations on why things are done the DAX way! Not only that but he is very patient and straight forward. Highly recommended!

R. Kemp, Canada

The course was an excellent investment overall, it exceed my expectations. It was well paced and presented. The instructor, Reza Rad, was excellent and was able to answer all my questions and explain complex idea in a manner that was easy to understand and follow. I had been using Power BI Desktop for a number of months prior to taking this course, but wish I had attended it sooner! The course structure of 1 day of overall Power BI and followed by 4 days of more intensive instruction on the various parts of Power BI allowed for a basic understanding of the whole, and then more comprehensive learning. The live-on-line experience worked well technically and allowed for questions and problem-solving with the instructor. I learned a lot about Power BI and this course gave me a great foundation for using Power BI to clean, model, design, and share reports using a variety of visualizations that will provide business intelligence to my company. I would recommend this course to anyone wanting to learn Power BI either as a starting point or even after you have used the tool to deepen your understanding and build your skill-set.

Who Attended RADACAD Training Courses

Register Here

Cancellation:
Cancellation up to 5 weeks before the event: full refund minus administration fee ($50) and credit-card processing fees (if applicable).

Cancellation from 5 weeks to 2 weeks before the event: 50% cancellation charge, 50% refund

Transfer fee to another event date* (from 2 weeks to 1 day before the event): 40% of the standard price of the event to transfer

Transfer fee at the day of event*: 60% of the standard price of the event to transfer

*transfer can be done only once, and it can be only transferred to another date not later than 6 months from the original event.
No Show:
No fee will be refunded for no show.

Save

Time

22 (Tuesday) 8:00 am - 23 (Wednesday) 4:00 pm GMT

Location

Auckland TBD

TBD

Organizer

Reza Radreza@radacad.com

Learn More

19nov8:00 am- 4:00 pmPower BI from Rookie to Rock Star - Module 4: Power BI for Data Architects (Architecture and Administration) – 1-day course Auckland Time Zone

Register Here

Course Title: Power BI from Rookie to Rock Star

Length:

From 1 to 9 days (Lecture + Labs): depends on the modules you enrol.

Delivery method:

In-Person or Online: Check the schedule of upcoming courses.

Type of training:

Public or private (contact us for more details)

The course is scheduled for Auckland’s time zone from 8:00 Am to 4:00 PM each day.

This course is delivered to thousands of people all around the world, check out only a few of the recommendations at the bottom of this page, and check some of our clients.

Instructor: Reza Rad

Power BI from Rookie to Rock Star

Module 1: Power BI for Data Analysts (2 days)
Module 2: Power BI for Data Wrangler and Transformer (2 days)
Module 3: Power BI for Data Modeler (2 days)
Module 4: Power BI for Architects (1 day)
Module 5: Power BI for Data Scientists (2 days)

Module 4: Power BI for Data Architects (Architecture and Administration) – 1-day course

The training includes but not limited to topics below:

4.1: Power BI Service

Power BI Components
Power BI Service Content; Dashboard, Report, and Dataset
Dashboard Features in the service
What is Gateway?
Two types of Gateway; On-premises, Personal
Configuration and Installation of Gateway
Import Data and Schedule Refresh
DirectQuery Connection
Live Connection
Composite Model

4.2: Sharing

Basic Dashboard or Report Sharing
Workspaces in Power BI; Dev Environment
Power BI Apps; User Environment
Publish to Web
Embed in SharePoint Online; Office 365 Integrated Sharing
Power BI Embedded; Embedding content into another application
Comparison of all Sharing methods

4.3: Security

Row Level Security
Dynamic Row Level Security
Patterns for Dynamic Row Level Security
Manager Level Access
Organization Chart Access as Dynamic Row Level Security
Profiles and Users; Dynamic Row Level Security
Dynamic Row Level Security using SQL Server Analysis Service Live Connection

4.4: Administration and Licensing

Power BI Administrator Configuration
Usage Metrics
Customizing Usage Metrics
Power BI Licensing Guide
Power BI Premium
Power BI Embedded Licensing

4.5: Integration

PowerPoint Integration with Power BI
Power BI and Excel; More than just an Integration
Power BI Report Server: Power BI on-premises
SQL Server Reporting Services Integration with Power BI
Real-time Streaming with Power BI, and Azure Stream Analytics
Power BI REST API

4.6: Architecture

Architecture for Enterprise Scale
Architecture for Sharing
Architecture for Self-Service
A tool that helps: Power BI Helper

Register Here

Why Power BI Training?

Common Myths about Power BI

Myth 1: Power BI is a self-service Excel tool, and isn’t suitable for Enterprise Solutions.

Myth 2: Power BI is easy to use, and doesn’t require a training course.

Myth 3: Power BI is only for Microsoft based environments and platforms.

Myth 4: Power BI is not a powerful and fully functional BI tool, and cannot be compared with other tools in the market.

In addition, there is always the possibility to use this as a hybrid approach and save lots of time and money along with great features that are only available in this product.

In-Person Training;

https://radacad.com/events

Online Training;

https://radacad.com/events

Use the letter written for your boss to convince him/her to pay for your Power BI Training course

Check Schedule of upcoming events here

Check cancellation policies and rates here

What others say about the training and trainer

Daniel R Tuma, Senior Systems Analyst at Cleveland Metro Schools, Ohio, USA

I spent probably about two weeks looking for a good Microsoft Power BI class that would cover all of the aspects of the program. I wanted to walk away from the class being able to apply what I learned immediately. Most training companies that I looked into were in a state of flux with Power BI mostly due to the transitions that Power BI itself was going through. Then I stumbled on the RADACAD web site. Reza Rad touted a course that he taught named “Power BI, From Rookie to Rock star.” If the class was indeed an A to Z course, then it was exactly what I was looking for. The class outline seemed to include every topic on my checkoff list plus much more. I decided to give Reza a try.
Reza completely lived up to his hype. He took us through a natural progression of the software, using example after example of how to complete a task. We went through real world scenarios, a bare minimum of two scenarios for each minor topic. I was completely impressed with his Power BI knowledge, understanding and abilities. Any question we came to Reza with was answered completely and with even more examples.
After the class, my goal of immediately applying what I learned was attained. Right away I was able to successfully pull and massage data, create useful reports and post them to dashboards.
I would recommend Radacad Power BI Training without hesitation.

Jeffrey Weir; Independent Consultant, Wellington, New Zealand

I learned a lot from this course: it gave a great overview of what’s possible both right from the UI, and what more awaits if you lift the hood and pimp the engine. It’s incredible to see just how much PowerBI and PowerQuery radically simplify what I would otherwise have to do with many, many lines of complicated VBA code. And Reza is a masterful user of this tool.

Note that Reza covers a lot of ground in this course, and it is pretty fast paced. While you can take a laptop and follow along as Reza takes PowerBI/Powerquery through its paces, for the one-day course my recommendation would be to keep that laptop closed, and simply sit back and watch Reza in action, so you can fully concentrate on just how simple this tool is to use in the right hands as well as think about how you might use the tool to your own ends and ask questions along those lines. You can always purchase the video course (if it’s not already included in your course) and step through the material again at your own pace.

Rob Wilby; Independent Consultant, UK

I must say your “Power BI Essentials” course has been the most comprehensive Power BI course I have found to date and seeing how you work with data especially the little tricks naturally introduced at just the right moments has made this course a pleasure to take.

Martin Catherall – Data Platform MVP, PASS Regional Mentor

I attended Reza’s Power BI pre-con “From Rookie to Rock star” at SQL Saturday Brisbane in May 2016. I was a complete Power BI novice, having only previously accomplished a few very basic things with Power BI. Reza took the group through all the components that make up environment. He explained how they had evolved and took the group through walk-throughs of each one. Reza was great an answering questions from the audience at the event and going into extra detail if necessary. All-in all, I would say that I’m now a very confident Power BI user after attending Reza’s pre-con.

Dan Cheshire, Senior Project Manager Air New Zealand

Reza does not just know Power BI like the back of his hand, he is the most commercially aware BI person I know. He understands that companies work in the real world and that data isn’t always clean and needs manipulation for it to work and be useful. When Reza worked on our project, nothing phased or flustered him, he always came up with solutions for problems that seemed to me as insurmountable. Can’t recommend him enough, invest in Reza as he will not only save you a whole heap of time, but he comes up with long lasting and very powerful Power BI solutions for your business.

Sonia Buckley, Data Analyst at Zoom2u, Sydney, Australia

We have started to use Microsoft Power BI and whilst Microsoft tutorials are helpful, if you are not used to DAX then it is very difficult to get your head around and there is little other resources that don’t cost an arm and a leg. I had a call with Reza who made my life so much easier in just under an hour! Any time spent speaking to Reza will be well worth it – I have saved hours of trying to get my head around our dashboards by getting some very useful tips and explanations on why things are done the DAX way! Not only that but he is very patient and straight forward. Highly recommended!

R. Kemp, Canada

The course was an excellent investment overall, it exceed my expectations. It was well paced and presented. The instructor, Reza Rad, was excellent and was able to answer all my questions and explain complex idea in a manner that was easy to understand and follow. I had been using Power BI Desktop for a number of months prior to taking this course, but wish I had attended it sooner! The course structure of 1 day of overall Power BI and followed by 4 days of more intensive instruction on the various parts of Power BI allowed for a basic understanding of the whole, and then more comprehensive learning. The live-on-line experience worked well technically and allowed for questions and problem-solving with the instructor. I learned a lot about Power BI and this course gave me a great foundation for using Power BI to clean, model, design, and share reports using a variety of visualizations that will provide business intelligence to my company. I would recommend this course to anyone wanting to learn Power BI either as a starting point or even after you have used the tool to deepen your understanding and build your skill-set.

Who Attended RADACAD Training Courses

Register Here

Cancellation:
Cancellation up to 5 weeks before the event: full refund minus administration fee ($50) and credit-card processing fees (if applicable).

Cancellation from 5 weeks to 2 weeks before the event: 50% cancellation charge, 50% refund

Transfer fee to another event date* (from 2 weeks to 1 day before the event): 40% of the standard price of the event to transfer

Transfer fee at the day of event*: 60% of the standard price of the event to transfer

*transfer can be done only once, and it can be only transferred to another date not later than 6 months from the original event.
No Show:
No fee will be refunded for no show.

Save

Time

(Tuesday) 8:00 am - 4:00 pm

Organizer

Reza Radreza@radacad.com

Learn More

3 Comments

Pingback: Introducción a Power BI: Qué es Power BI? | inteligencia-de-negocios.cominteligencia-de-negocios.com
Darryll Petrancuri says:

August 19, 2016 at 7:58 am

Reza:

I respect your contributions to community and commitment to the Microsoft BI Stack and your knowledge of all things Power BI.

To that end, would you be so kind as to read the post at the following link and share your comments regarding such with me as well as the Power BI team.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15708798-power-bi-enterprise-gateway-fails-to-set-session-c

I believe I’ve made a salient case for the need for a fix to what I believe to be a critical design flaw in the implementation of the Power BI Enterprise Gateway when connecting to SQL Server 2016 or Azure SQL DB or Azure SQL DW.

Thank you for your consideration and learned reply.

Respectfully,

Darryll Petrancuri
@SQLArchitect

Pingback: Blir du med til Summit EMEA i april?

3 Comments

Leave a Reply Cancel reply

Event Details

Event Details

Course Title: Power BI from Rookie to Rock Star

Instructor: Reza Rad

Power BI from Rookie to Rock Star

Module 2: Power BI for Data Wrangler/Transformer (Data Transformation) – 2 days course

Why Power BI Training?

Common Myths about Power BI

Myth 1: Power BI is a self-service Excel tool, and isn’t suitable for Enterprise Solutions.

Myth 2: Power BI is easy to use, and doesn’t require a training course.

Myth 3: Power BI is only for Microsoft based environments and platforms.

Myth 4: Power BI is not a powerful and fully functional BI tool, and cannot be compared with other tools in the market.

In-Person Training;

Online Training;

What others say about the training and trainer

Time

Location

Organizer

Learn More

Event Details

Event Details

Course Title: Data Science and Advanced Analytics with Microsoft Technologies

Module 2: Data Science with Microsoft Cloud – 2 days course

In-Person Training;

Online Training;

What others say about the training and trainer

Time

Location

Organizer

Learn More

Event Details

Event Details

Description

Time

Location

Organizer

Learn More

Event Details

Event Details

Course Title: Power BI from Rookie to Rock Star

Instructor: Reza Rad

Power BI from Rookie to Rock Star

Module 3: Power BI for Data Modeler (Data Modelling and DAX) – 2 days course

Why Power BI Training?

Common Myths about Power BI

Myth 1: Power BI is a self-service Excel tool, and isn’t suitable for Enterprise Solutions.

Myth 2: Power BI is easy to use, and doesn’t require a training course.

Myth 3: Power BI is only for Microsoft based environments and platforms.

Myth 4: Power BI is not a powerful and fully functional BI tool, and cannot be compared with other tools in the market.

In-Person Training;

Online Training;

What others say about the training and trainer

Time

Location

Organizer

Learn More

Event Details

Event Details

Course Title: Data Science and Advanced Analytics with Microsoft Technologies

Module 3: Advanced Data Science with Microsoft Services – 2 days course

In-Person Training;

Online Training;

What others say about the training and trainer

Time

Location

Organizer

Learn More

Event Details

Event Details

Course Title: Power BI from Rookie to Rock Star

Instructor: Reza Rad

Power BI from Rookie to Rock Star

Module 2: Power BI for Data Wrangler/Transformer (Data Transformation) – 2 days course

Why Power BI Training?

Common Myths about Power BI

Myth 1: Power BI is a self-service Excel tool, and isn’t suitable for Enterprise Solutions.

Myth 2: Power BI is easy to use, and doesn’t require a training course.

Myth 3: Power BI is only for Microsoft based environments and platforms.