DATA ANALYSIS POSTING

  With a mix of Power BI & Excel's versatility and coding experience, You can easily wrangle any kind of data and get the most out of it. Let's see how we can use python in two processes (Data Wrangling & Data Visualization) inside Power BI Make sure that anaconda and python3 installed on your pc. Our Data set The dataset I'm using for this article is a Kaggle dataset that I've recently worked on you can check it out here what we are going to do is to transform some of my work in this notebook to power bi. 2. Data wrangling The data wrangling process in power bi is based inside the query editor After loading your data click on the transform tab then run a python script then you will need to import your libraries and run your code for me, the dataset only needed to replace some values and to get the date and time  for more information check out my Kaggle notebook You will get this after running your code this is the new dataset after running your code  so all you...

Connecting MySQL to Power BI Step By Step: Know Your Server's Name and Your Database's Name Connect to your server From server statues, get the name of your server (Host:) From Schemas get your database's name Connect Via Power BI Select Mysql as a Datasource Type your server's name and your database's you can also run a SQL query before importing Select the tables you want to import  Regards.

  Have you ever questioned if it is feasible to move all of the measures from one Power BI PBIX file to any other PBIX file ? Imagine you've got 2 PBIX files with the same models, i.e all tables used in the measures have the same data structure. If someday you are in this position then there will be a lot of measures to move from one file to another. Copying and pasting measures one by one can be a test from hell. It is a wolf in sheep’s clothing. It takes your efforts as well as your time.   So how to do it at one go?    Here is the solution for it! You will need an external tool Tabular Editor for this. If you already don't have it, then please install it first. You can visit the  Tabular Editor website  to download the latest installer.   You will then have 2 running instances of Power BI Desktop on your PC as you need to open both the pbix files at the same time. Make sure you are clear which file is which. Just rename your files for bett...

  Create slideshows from notebooks is one of my favorite features. You can see  an example of a slideshow here  introducing pandas for working with data. The slides are created in notebooks like normal, but you’ll need to designate which cells are slides and the type of slide the cell will be. In the menu bar, click View > Cell Toolbar > Slideshow to bring up the slide cell menu on each cell. Turning on Slideshow toolbars for cells will show a menu dropdown on each cell that lets you choose how the cell shows up in the slideshow. Turning on Slideshow toolbars for cells, This will show a menu choose slide type, Slides are full slides that you move through left to right. Sub-slides show up in the slideshow by pressing up or down. Fragments are hidden at first, then appear with a button press. You can skip cells in the slideshow with Skip and Notes leaves the cell as speaker notes. the dropdown on each cell that lets you choose how the cell shows up in the slideshow. T...

  This magic trick is to export your data sets to excel as a data model, not a table so it can hold millions of rows. sol let's go over this step by step. Open your Power BI file and a new Excel File Then Power Pivot is an add-in that you can use to perform powerful data analysis in Excel. Here’s how you enable Power Pivot before using it for the first time. Go to File > Options > Add-Ins. In the Manage box, click COM Add-ins> Go. Check the Microsoft Office Power Pivot box, and then click OK. To get this magic address, from your Power BI file open Dax studio and see the next screenshot In the right lower corner you can see our magic address Follow this link to see how to connect Dax studio to Power BI Here's your data you can easily load it to your data model You can also do the same using power query instead of power pivot  Regards.

  There are 2 ways to export data from Power BI to a CSV file, an easy one and a professional one.