SQL Atlanta BI Atlanta BI Edition
2019-10-19 12:30 - 13:30 (America/New_York) | Microsoft Office Alpharetta, 8000 Avalon Boulevard, Suite 900, Alpharetta, GA, 30009, United States
SQL Saturday Atlanta (BI Edition) will be held on October 19th. I’ll present a “Power BI Pro, or Premium: that is the question” strategy-oriented session at 12:30.
“One question that always pops us during my Power BI assessments for companies planning to adopt Power BI is which SKU to buy. The choice might seem obvious to your organization, but there is much more below the surface. Join this session and learn important considerations that might influence your decision, including:

Licensing cost
Hosting organizational semantic layers
External reporting
Features
On-premises reporting”

Atlanta MS and Power BI Group Meeting
2020-02-03 18:30 - 20:30 | Microsoft Office Alpharetta, 8000 Avalon Boulevard, Suite 900, Alpharetta, GA, 30009, United States
Aggregations in Power BI
Aggregations are one of the most important optimization methods for managing big datasets in Power BI. Combined with Direct Query storage mode, they allow big datasets to be analyzed efficiently by answering high level analytical queries quickly from memory while sending more detailed queries back to the source database. In this session, you will learn about the concept of aggregations, different table storage modes in Power BI, different kinds of aggregation tables, how to configure aggregation tables so that they can answer high level user queries, and finally how to use tools such as DAX Studio or Extended Events to determine if the aggregations are actually being used.

Power Platform World Tour Precon
2020-02-10 09:00 - 17:00 | Atlanta Marriott Marquis, 265 Peachtree Center Ave NE, Atlanta, GA, 30303, United States
Organized by Microsoft and Dynamic Communities, the Power Platform World Tour will take a place in Atlanta from 2/10-2/12, 2020. I’m teaching Power BI Dashboard in a Day (DIAD) on Feb 10 for a full day. Although this is a paid event ($599), you should get a great business value as the audience will probably be smaller and I’ll be able to provide more personal attention.

Bridge Analytics and Developer Worlds with Power Platform
2020-02-12 10:15 - 11:15 | Atlanta Marriott Marquis, 265 Peachtree Center Ave NE, Atlanta, GA, 30303, United States
One of the Power BI most prominent strengths is that it’s a part of the much broader Microsoft Data Platform that spans various on-premises and cloud offerings for data storage, processing, and analysis. Join me to learn how to integrate Power BI with PowerApps and discover exciting new possibilities that redefine the meaning of a report and let you do more with less. During this entirely hands-on, almost no-slides session I’ll walk you through the steps to implement a popular report requirement for writeback, that Power BI doesn’t natively support.

Virtual Power BI Dashboard in a Day (DIAD) on April 14
2020-04-14 09:00 - 17:00 | Virtual Meeting
Are you looking for an agile self-service BI platform that doesn’t require reporting and query skills to get basic analytics done without reliance on IT? Partnering with Microsoft, Prologika is pleased to offer an 1-day instructor-led workshop covering the end-to-end self-service BI process with Power BI. Redesigned for digital delivery, this workshop will help you understand how to analyze your data in a rich and compelling way. Whether you are evaluating its ability to meet organizational requirements around data visualization and analysis or are looking to learn how Power BI can help you be more efficient and make a greater impact on the work you do every day, this is the training for you.

Attend this insightful 1-day workshop from anywhere for only $199, when Teo Lachev (CEO of Prologika, a Power BI Red Carpet Partner) teaches you practical Power BI knowledge and data analytics skills that you can immediately apply to your job. See how Power BI can improve your usability and productivity even further.

Key Benefits
At the end of the day, you’ll learn how to:

Connect to, import, and transform data from a variety of sources
Define business rules and KPIs
Explore data with powerful visualization tools
Build stunning reports
Share their dashboards with their team and/or the world
Learn best practices and get your questions answered

Agenda
The workshop will be conducted online. Login instructions will be sent to registered attendees before the event. All times are Eastern Time zone (GMT-4).
Morning
09:00 AM –10:00 AM –Introduction to Power BI
10:00 AM –10:30 AM–Lab 1 Accessing & Preparing the data
10:30 AM –10:45 AM – Break
10:45 AM –11:15 AM –Lab 1 Solution + Questions
11:15 AM –11:45 AM –Lab 2 Data Modeling and Exploration
11:45 AM –12:30 PM –Lab 2 Solution + Questions
12:30 PM –01:00 PM –Break for lunch
Afternoon
01:00 PM –01:30 PM–Lab 3 Visualizations
01:30 PM –02:00 PM–Lab 3 Solution + Questions
02:00 PM –02:30 PM –Lab 4 Publishing and accessing Reports
02:30 PM –02:45 PM–Break
02:45 PM –03:15 PM–Lab 4 Solution + Questions
03:15 PM –03:45 PM–Lab 5 Building a Dashboard and Sharing
03:45 PM –04:15 PM–Lab 5 Solution + Questions
04:15 PM –05:00 PM–Q&A
Your Instructor
Through his Atlanta-based company Prologika (https://prologika.com), a Microsoft Gold Partner in Data Analytics, Teo Lachev helps organizations make sense of their most valuable asset: their data. His strategy formulation, trusted advisory and mentoring, design and implementation services empower clients to apply effectively data analytics in order to understand, improve, and transform their business processes. Teo has authored and co-authored several books on organizational and self-service data analytics, and he has been leading the Atlanta Microsoft BI and Power BI group since he founded it in 2010. Microsoft has awarded Teo the Most Valued Professional (MVP) – Data Platform award every year since 2004 for his expertise and contributions to the community.

Cancellation Policy
Tickets are not refundable but can be reassigned to someone else if you can’t attend.

Virtual Power Platform App in a Day (AIAD) on April 21
2020-04-21 09:00 - 17:00 | Virtual Meeting
Are you looking for an agile self-service platform for automating business process that doesn’t require reliance on IT? PowerApps is a low or no-code application builder from Microsoft that gives you a way to do more with less and deliver applications to your end-users at a rapid pace. Partnering with Microsoft, Prologika is pleased to offer an 1-day instructor-led workshop covering the fundamentals of the Microsoft Power Platform which encompasses Power Apps, Power Automate, Power BI, and Common Data Services (CDS). Redesigned for digital delivery, this workshop will help you automate processes in your organization without writing code!

Attend this insightful 1-day workshop from anywhere for only $199, when Teo Lachev (CEO of Prologika, a Power BI Red Carpet Partner) teaches you practical knowledge that you can immediately apply to your job. See how Power Platform can improve your usability and productivity and transform your organization business.

Key Benefits
At the end of the day, you’ll learn how to:

Implement highly-customizable Power Apps canvas applications that can run on any device
Store and retrieve data from Common Data Services (CDS) to avoid provisioning database servers
Create model-driven apps for data entry forms and workflows
Apply Power Automate to automate business processes, such as an approval flow
Implement a Power BI model to analyze the app data
Learn best practices and get your questions answered

Agenda
The workshop will be conducted online. Login instructions will be sent to registered attendees before the event. All times are Eastern Time zone (GMT-4).
Morning
09:00 AM –10:00 AM –Introduction to Power Platform
10:00 AM –11:15AM–Lab 1 Canvas Apps
11:15AM –12:30PM –Lab 2 Common Data Service
12:30 PM –01:00 PM –Break for lunch (finish lab 2 over lunch)
Afternoon
01:00 PM –02:30 PM–Lab 3 Model-driven apps
02:30 PM –03:30 PM –Lab 4 Power Automate
03:30 PM –04:30PM–Lab 5 Power BI
04:45PM –05:00 PM–Q&A
Your Instructor
Through his Atlanta-based company Prologika (https://prologika.com), a Microsoft Gold Partner in Data Analytics, Teo Lachev helps organizations make sense of their most valuable asset: their data. His strategy formulation, trusted advisory and mentoring, design and implementation services empower clients to apply effectively data analytics in order to understand, improve, and transform their business processes. Teo has authored and co-authored several books on organizational and self-service data analytics, and he has been leading the Atlanta Microsoft BI and Power BI group since he founded it in 2010. Microsoft has awarded Teo the Most Valued Professional (MVP) – Data Platform award every year since 2004 for his expertise and contributions to the community.

Cancellation Policy
Tickets are not refundable but can be assigned to someone else if you can’t attend.

Virtual Power BI Dashboard in a Day (DIAD) on April 30
2020-04-30 09:00 - 17:00 | Virtual Meeting
Are you looking for an agile self-service BI platform that doesn’t require reporting and query skills to get basic analytics done without reliance on IT? Partnering with Microsoft, Prologika is pleased to offer an 1-day instructor-led workshop covering the end-to-end self-service BI process with Power BI. Redesigned for digital delivery, this workshop will help you understand how to analyze your data in a rich and compelling way. Whether you are evaluating its ability to meet organizational requirements around data visualization and analysis or are looking to learn how Power BI can help you be more efficient and make a greater impact on the work you do every day, this is the training for you.

Register for this workshop to hone your data analytics skills! Drive value for your organization and on the road
to recovery after COVID-19. Attend from anywhere for only $199, when Teo Lachev (CEO of Prologika, a Power BI Red Carpet Partner) teaches you practical Power BI knowledge and data analytics skills that you can immediately apply to your job. See how Power BI can improve your usability and productivity even further.

Key Benefits
At the end of the day, you’ll learn how to:

Connect to, import, and transform data from a variety of sources
Define business rules and KPIs
Explore data with powerful visualization tools
Build stunning reports
Share their dashboards with their team and/or the world
Learn best practices and get your Power BI questions answered

Agenda
The workshop will be conducted online. Login instructions will be sent to registered attendees before the event. All times are Eastern Time zone (GMT-4).
Morning
09:00 AM –10:00 AM –Introduction to Power BI
10:00 AM –10:30 AM–Lab 1 Accessing & Preparing the data
10:30 AM –10:45 AM – Break
10:45 AM –11:15 AM –Lab 1 Solution + Questions
11:15 AM –11:45 AM –Lab 2 Data Modeling and Exploration
11:45 AM –12:30 PM –Lab 2 Solution + Questions
12:30 PM –01:00 PM –Break for lunch
Afternoon
01:00 PM –01:30 PM–Lab 3 Visualizations
01:30 PM –02:00 PM–Lab 3 Solution + Questions
02:00 PM –02:30 PM –Lab 4 Publishing and accessing Reports
02:30 PM –02:45 PM–Break
02:45 PM –03:15 PM–Lab 4 Solution + Questions
03:15 PM –03:45 PM–Lab 5 Building a Dashboard and Sharing
03:45 PM –04:15 PM–Lab 5 Solution + Questions
04:15 PM –05:00 PM–Q&A
Your Instructor
Through his Atlanta-based company Prologika (https://prologika.com), a Microsoft Gold Partner in Data Analytics, Teo Lachev helps organizations make sense of their most valuable asset: their data. His strategy formulation, trusted advisory and mentoring, design and implementation services empower clients to apply effectively data analytics in order to understand, improve, and transform their business processes. Teo has authored and co-authored several books on organizational and self-service data analytics, and he has been leading the Atlanta Microsoft BI and Power BI group since he founded it in 2010. Microsoft has awarded Teo the Most Valued Professional (MVP) – Data Platform award every year since 2004 for his expertise and contributions to the community.

Cancellation Policy
Tickets are not refundable but can be reassigned to someone else if you can’t attend.

Power BI Time Intelligence – Beyond the Basics
2020-05-04 06:30 - 20:30 | Virtual Meeting
Time-Intelligence refers to analyzing calculations and metrics across time and is the most common type of business intelligence reporting. Power BI has a lot of built in capabilities to help you get started but these alone are not always enough for most real-world solutions. The key to mastering time-intelligence in Power BI is a good date table and understanding how to manipulate the filter context. This session will teach you how to do both!
In this (demo-heavy) session, we’ll quickly review Power BI’s built-in time intelligence capabilities and why you should avoid them! We’ll also cover the importance of a good date table, what attributes it should include, and how it can be leveraged to simplify complex time-intelligence calculations. Finally, we’ll breakdown a handful of the 40+ DAX time-intelligence functions, showing you how they work under the covers (hint: filter context) and how they can used in combination to accommodate complex business logic.
