Month: June 2022

What are the main tools for Azure Synapse and SQL???

Posted on by Annie D

Getting started with Azure Synapse Analytics or Azure SQL Database? Or even Microsoft SQL Server in general? Patrick shows you how to use some of the common tools and be able to connect to your instance!

Download SQL Server Management Studio
https://docs.microsoft.com/sql/ssms/download-sql-server-management-studio-ssms

Download and install Azure Data Studio
https://docs.microsoft.com/sql/azure-data-studio/download-azure-data-studio

šŸ“¢ Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

šŸŽ“ Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— <a href="http://twitter.com/patrickdba" Continue reading “What are the main tools for Azure Synapse and SQL???” →

Duplicates in Row? Conditional Formatting, Counting and Logical Formula. Excel Magic Trick 1793

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1793.xlsx
Learn how to determine if there are duplicates in a row.
Topics:
1. (00:00) Introduction
2. (00:09) Logical Formula to indicate if duplicates are in row. OR and COUNTIFS functions.
3. (03:02) Conditional Formatting to indicate if duplicates are in row. COUNTIFS function.
4. (05:54) Count Unique Items with UNIQUE and COLUMNS functions.
5. (06:45) Logical Formula to indicate if duplicates are in row. COLUMNS and UNIQUE functions.
6. (07:29) Count Unique Items with FREQUENCY, MATCH, COLUMN and SUM functions. Old School Formula.
7. (07:59) Summary
8. (08:20) Closing, Video Links

How To Create Dynamic Temporal Scale In Power BI Pt.1

Posted on by Annie D

Every so often weā€™ll be needing the availability of a custom visual of a bar chart or line chart that gives an option to plot the chart either weekly, monthly, quarterly, or yearly.Ā In this video, Greg is going to demonstrate how you can create dynamic temporal scale using calculated columns in Power BI that can let you change the level of granularity depending on your date or time basis.
ļæ¼
***** Video Details *****
00:00 Introduction
00:47 What is a dynamic temporal scale
01:40 Use cases
02:48 R10_Table
03:05 IsCurrentQuarter
03:48 DTS
04:40 DTS Sort By
06:45 Limitations of calculated column

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Continue reading “How To Create Dynamic Temporal Scale In Power BI Pt.1” →

How To Create External Tools For Power BI (Part 1)

Posted on by Annie D

RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/webinar-series-resources-free/

When is it?
June 14th – 2pm Los Angeles (PDT), 5pm New York (EDT), 10pm London (BST)
June 15th – 7am Sydney (AEST), 9am Auckland (NZST)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Greg Deckler (MVP) – VP at Fusion Alliance

During This Free Training, You Will Learn:

ā€¢ Create external tool to generate the Enterprise DNA extended date table (Holidays, Some Date Intelligence Measures, Set Sort By)
ā€¢ Time Machine
ā€¢ Text box for naming the date table
ā€¢ Date picker for StartDate and EndDate

If Continue reading “How To Create External Tools For Power BI (Part 1)” →

Dad & Son Seattle Jefferson Sunday Skatepark Rad: Boneless-Ones Skate Music Pumps The Action!

Posted on by Annie D

Isaac ā€œIcemanā€ Girvin and his dad, Mike ā€œMagicā€ Girvin (excelisfun at YouTube), ride at Jefferson Skate Park on Sunday, June 12, 2022.
The Boneless Ones Skate Punk Band Sond Back To The Grind pumps the action and creates rad!
Washington BMX / Skate Adventure 16.

šŸ”“ Power BI tips from the Pros – LIVE (June 18, 2022) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about Power BI!

šŸ’„ 30 minutes: Open Q&A (Public)
šŸ’„ Then… Members Only Chat (Public can watch & Super Chat for Questions)

šŸ“¢ RULES FOR Q&A: šŸ“¢

šŸ‘‰ Put a “Q:” in front of your comment to help us identify questions!
šŸ‘‰ Super chats take priority
šŸ‘‰ Do NOT re-post your questions! We’ll get to as many questions as we can.
šŸ‘‰ If you SPAM your question, you will be put in timeout

šŸ“¢ Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you Continue reading “šŸ”“ Power BI tips from the Pros – LIVE (June 18, 2022) (Member Chat 2nd Half)” →

How To Handle Missing Data In Python With Interpolation

Posted on by Annie D

InterpolationĀ is a method for generating points between given points. In Python, Interpolation isĀ a technique mostly used to impute missing values in the data frame or series while preprocessing data. In this tutorial, Gaelim is going to show how you can use Interpolation to estimate missing data points in your data using Python in Power BI.

DESCRIPTION:

***** Video Details *****
00:00 Introduction
00:25 Original data
00:49 Types of estimation
01:17 Methods of interpolation
03:46 Data set
04:39 Data types
06:22 Index
07:05 Nearest interpolation
09:12 Linear interpolation
09:16 Weighted time interpolation
09:42 Flag
11:15 Troubleshooting & test run

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – <a href="http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi" Continue reading “How To Handle Missing Data In Python With Interpolation” →

šŸ”“ Power BI tips from the Pros – LIVE (June 11, 2022) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about Power BI!

šŸ’„ 30 minutes: Open Q&A (Public)
šŸ’„ Then… Members Only Chat (Public can watch & Super Chat for Questions)

šŸ“¢ RULES FOR Q&A: šŸ“¢

šŸ‘‰ Put a “Q:” in front of your comment to help us identify questions!
šŸ‘‰ Super chats take priority
šŸ‘‰ Do NOT re-post your questions! We’ll get to as many questions as we can.
šŸ‘‰ If you SPAM your question, you will be put in timeout

šŸ“¢ Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you Continue reading “šŸ”“ Power BI tips from the Pros – LIVE (June 11, 2022) (Member Chat 2nd Half)” →

Power BI External Tool with Greg Deckler

Posted on by Annie D

Analyzing, interpreting, and monitoring data is crucial for a business or an organization, and things have never been easier than using Power BI.

Microsoft Power BI creates an analytical environment for monitoring data and sharing reports. It delivers interactive data visualization BI capabilities allowing users to see and share data and insights throughout their organization.

In this episode of The Analytic Mind Podcast, Sam McKay interviews Greg Deckler, Vice President (Microsoft) at Fusion Alliance and is also part of the team at Enterprise DNA, helping them move the needle on some great initiatives.

Find out many exciting things that Continue reading “Power BI External Tool with Greg Deckler” →

Intro To Enterprise DNA Challenge 20 – Sales And Production Analysis

Posted on by Annie D

We were shocked with the outstanding participation for Challenge 19 ā€œCall Centres Data Reportingā€ that produced 55 great entries with more than 200+ report analysis pages, 150+ navigation buttons, bookmarks, and tooltips. The variety of native and customs visuals in the reports is a proficiency in Data Visualization.ā€ÆHowever, everyone wants to enjoy more! Weā€™re back with an equally exciting case scenario for Challenge 20.

This challenge is a great opportunity to learn a valuable skill of being able to produce and calculate Production and Forecast Reports within Power BI. The techniques covered here are massively reusable across the board. Watch as Continue reading “Intro To Enterprise DNA Challenge 20 – Sales And Production Analysis” →

How To Calculate Percentages In A Hierarchical Form In Power BI

Posted on by Annie D

You might encounter a requirement where youā€™ll need to display the ratio percentage of a particular level in your data against a parent level, and many might find this to be a tricky task as there is no straightforward function to achieve this result. In this video, Harsh is going to demonstrate how you can calculate percentages in hierarchical form.

***** Video Details *****
00:00 Introduction
01:14 The matrix
01:35 % of total sales
03:06 Total sales
04:08 Total sales per territory
04:44 Total sales per product
06:21 % of sales per territory
06:57 % of sales per product
08:12 Results

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Continue reading “How To Calculate Percentages In A Hierarchical Form In Power BI” →

Intro To Paginated Reports By Sue Bayes – New Course

Posted on by Annie D

Access the course here: https://portal.enterprisedna.co/p/intro-paginated-reports-1

Power BI reports are known for their interactive and dynamic visuals. There are times though when you’ll need to use a paginated report for when your report needs to be printed out or turned into a PDF document.

Get to learn how you can optimize your report so that it is easily readable and would fit appropriately on a page with our newly released course ā€œIntro to Paginated Reportsā€ developedĀ and instructed by Microsoft Power BI Developer & Business Analyst,Ā Sue Bayes.

In this video, Brian is joined by Sue to officially rollout this new course Continue reading “Intro To Paginated Reports By Sue Bayes – New Course” →