Power Platform Summit Australia

Never stop learning , volunteering , looking for opportunity and work for communities, I had given a great opportunity to be a program committee track leader for Power Platform Summit Australia which is going to happen on 21-23 August 2019 at Crown Promenade Melbourne.

Thanks to the Power Platform Summit Australia 2019 Program committee team for giving me this opportunity to work as a Volunteer Program committee track leader for upcoming Power Platform Summit Australia 2019 in Measure track focusing on Building and Designing Dashboards and Reports.

I had given opportunity in Measure track (Focus: Building and Designing Dashboards and Reports) and mainly Measure (Power BI) track is for -Focus: Building and Designing Dashboards and Reports:

Use any data, from hundreds of sources to easily create compelling, interactive visualizations. Every stunning visual or valuable reports relies on good data which starts with importing, cleaning, transforming and modeling your data. This important step is where all good BI solutions start. Learn to take the hundreds of sources you need and how to properly prepare your data and uncover insights in the future. Then customize your visuals to fit your brand and your audience, including storytelling with data to drive even more impact. This track will offer sessions at every level to help you get started or continue extending your skills by creating and customizing. Targeted roles: Business Analysts, Power Users, Business Users

So Why Power Platform Summit Australia 2019?

Learn. Network. Engage.

Across industries and around the world, this event is known as a premier user-centric experience for Power BI, PowerApps, and Flow product users.
With credible peer-to-peer knowledge exchange at its core, this event will help you uncover solutions for everyday challenges and establish organizational goals.

Through focused learning and networking, you will:

Experience a community-driven environment dedicated to un-biased support and problem-solving.
Network with peers from your region, industry or in a similar role for a customized event experience.
Receive tips on how to maximize software performance and increase product ROI.

You can find more on Power Platform Summit Australia 2019 by going through below link.

https://www.australiasummit.com/explore/power

Also, you can register for the event and also for the pre-conference academy event from the link below

https://www.australiasummit.com/summitaustralia/pricing

It feels great that my session also got selected, really happy and exciting. I will be speaking on

(AUSD07) Microsoft Power BI, Python to Visualize and Predict Connected Car

This session is mainly use to learn more about Power BI, Python and Azure ML and different visualization chart. How we can use Power BI and Python to visualize and predict the connected car from the IOT sensors related data of connected cars.
From this session one can learn how can we make some simple and quick visualization using Power BI desktop taking IOT Sensors data and publish into PowerBI cloud service and also publish those visualization reports to publicly in web. Also, this session mainly helps to tell the story of connected car driver movement patterns and helps to understand and predict which driver or car might be unsafe or risky one.
Overall, by using Power BI and Python and Azure ML how one can use analytics and prediction.
So, this session will surely help one to learn regarding Power BI, Python and Azure ML and its capabilities

Also, you can check the different session’s schedules from great speaker and MVP’s around the world.

#PowerPlatformSummit

some memories of Power Platform Summit Australia 2019

https://www.instagram.com/p/B1bSmkPFqvc/

Regards,

Anil Maharjan

Community Leader/Speaker: Nepal Power BI User Group

Memories of Axiata Data Science Forum and Data Unchained Malaysia 2018 Datathon | Power BI | Microsoft Azure Machine Learning

This time I got an opportunity to visit Axiata Data Science Forum, kuala lumpur and to be part of Data Unchained Malaysia 2018 Datathon . Axiata Data Science Forum is organized by our head office Axiata Group.

Beside than Data science Forum this year we had an quite interesting and challenging datathon competition which is organized by Axiata Group and the Asia School of Business (established in collaboration with MIT Sloan), Data Unchained Malaysia 2018 is the first regional and Malaysia’s biggest datathon revolving around the rise of 5G and IoT and how these technologies enable smart cars. You can find more on this from below link:

https://www.axiata.com/dataunchained/

Here we have got the masking data related to connected cars, IOT sensors and have to implement different use cases. I must say it was a quite interesting and challenging competition or datathon I have ever been. Here, we used Power BI, Python, and Azure ML to implement the use cases given.

One can learn more about Python, PowerBI and Microsoft Azure ML from below links:

https://www.python.org/

https://studio.azureml.net/

https://azure.microsoft.com/en-us/

https://powerbi.microsoft.com/en-us/

https://www.pbiusergroup.com/kathmandu

https://gallery.azure.ai/

https://docs.microsoft.com/en-us/azure/machine-learning/studio/algorithm-cheat-sheet

It was full of excitement and happy that I got a chance to meet and network with colleagues around the Axiata Family and also had opportunity to meet great people around the world.

Some snaps of datathon related to Power BI, Azure ML visual:

Thanks,

Anil Maharjan

Senior BI Engineer | Microsoft Data Platform MVP | Nepal Power BI User Group Leader

Memories of DATA & BI Summit 2018 | Dublin, Ireland.

The journey which we have thought in our mind but couldn’t make it happen due to different things. But this year I got an opportunity to represent myself, my country Nepal and overall Nepal Power BI User Group in DATA and BI Summit 2018 which was held in Dublin, Ireland on 23rd April to 26th April, 2018 at The Convention Centre Dublin.

https://www.databisummit.com/home

https://www.pbiusergroup.com/kathmandu

I was also appointed to be a Program Committee member for this DATA and BI Summit 2018 in Visualize Track, where we team up in group to review different abstracts from different great speakers around the world. We work really hard to finalize the content and selected the best suitable sessions for this summit with the help of Rose, Mark and mainly all the members of Program Committee. During these abstract review process I came to know different tools, techniques, process and methods related to different Microsoft Products mainly focusing PowerBI visuals. It was in deed a great opportunity and responsibility to be a Program Committee of any Summit or conference. We must thanks to all the members of Program Committee Team.

https://www.pbiusergroup.com/about/programming

I was also given an opportunity to be a speaker at this summit and I really got happy when I knew this. And then my journey begins to attend DATA & BI Summit 2018 as a Speaker from my country Nepal.

This time DATA and BI Summit 2018 is held at Dublin, Ireland and getting visa from Nepal to Ireland or European Visa is difficult for developing countries like us Nepal. I don’t know why the process took nearly 1 month to get a visa from Nepal to Ireland though I finally got the visa for which I had prepared all the necessary documents and process followed as per VFS Nepal in order to get Ireland visa. Thanks again for Ireland Embassy ,India for granting me for conference visa since in Nepal there is no Ireland Embassy located here.

If anyone wants to attend these types of Microsoft conference or other conference in Ireland from Nepal then you can follow below VFS links. (Also don’t depends on VFS only since my case they said visa process will take maximum 15 days but which took me nearly 1 month, luckily I had applied nearly 1 month before my conference date).

http://www.vfsglobalirelandvisa.com/india/how_to_apply.html

Had a great experience about Ireland, people, speakers around the world, MVPs, PUG Leaders and Microsoft Families and also Nepalese brothers from my own hometown Siddhipur ,Lalitpur who helps me a lot while I was in Ireland. Really thanks to all for being so humble and helpful.

Also, I had posted as below after the DATA & BI Summit 2018:

It was full of excitement and happy that I got a chance to meet some of my idols Jen Stirrup , Chris Webb , Reza Rad , leila Etaati ,Data Geeks ,BI hero’s ,MVP, and Microsoft Power BI Team . Thanks a lot to Rose Spitzer , Jena Coffie , Mark Wilcock and Microsoft PUG team for giving me this opportunity. Feeling happy happy 🙂 .#DataBISummit #PowerBI #PUG #MicrosoftYou can find more on below link

https://www.databisummit.com/home

The official Thank you to DATA & BI Summit Volunteers Video:

Some of the snaps during my journey to DATA & BI Summit 2018, Dublin, Ireland.

https://www.instagram.com/p/BiCt3zsFQiZ/?taken-by=anil_maharjan

Microsoft Data Platform MVP and My MVP Award Kit Arrived :)

On early morning 2^nd March 2018, the day I got surprised mail from MVP Global Administration which made be happy and exciting 🙂 .

On the same day I post this message after receiving mail from MVP Global Administration.

It is a great honor and pleasure for me to know that I got my first MVP award today in Data Platform. Feels really happy and exciting 🙂 . Thank you everyone personally for all the help and support that you gave and who made me believe on achieving this award. Look forward to contribute and volunteer more as MVP. #MVP #MVPAward #Microsoft After a week I got the mail again from MVP Global Administration regrading my MVP Award Kit shipping information.After 10 days on 13^th March, 2018 My MVP Award Kit arrived in my company located at Nepal. Which made me feel happy and honored again 🙂 . On next day I post the message again as:

My MVP Award Kit Arrived 🙂 . Thank you Microsoft. Thank you everyone personally for all the help and support that you gave and who made me believe on achieving this award. Thank you Soyoung Lee , Andreas Wolter , Jen Stirrup , Shree Prasad Khanal , Deependra Bajracharya, Gogula Aryalingam , Nagaraj Venkatesan , Shrwan Shrestha , Nepal Power BI User Group, Himalayan SQL Server User Group , my friends and my family !!! #MVP #MVPAward #Microsoft

Thanks Microsoft for this opportunity and I look forward to contribute and volunteer more as MVP.

To know more about MVP and MVP Award Program. You can check on below site in detail. https://mvp.microsoft.com/

My MVP Profile:

https://mvp.microsoft.com/en-us/PublicProfile/5003040?fullName=Anil%20%20Maharjan

Using Microsoft Azure Stream Analytics and Power BI: Real-time Telco fraud detection

This post is referenced from Microsoft Azure main articles, during my free time I want to try out Azure Stream Analytics and know more about the Stream Analytics where I found two great articles which help me to understand in detail:

Below are those articles:

1) https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-real-time-fraud-detection

2) https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-power-bi-dashboard

Here one can learn related to Azure Steam Analytics and how Power BI visualization dashboard can be used for real time data analysis and helps to visualize fraudulent phone calls that are detected by a Streaming Analytics job in real time. Since, I am also currently working in Telco sector so this analysis helps me a lot.

This tutorial provides an end-to-end illustration of how to use Azure Stream Analytics. You learn how to:

Bring streaming events into an instance of Azure Event Hubs. In this tutorial, you’ll use an app that we provide that simulates a stream of mobile-phone metadata records.
Write SQL-like Stream Analytics queries to transform data, aggregating information or looking for patterns. You will see how to use a query to examine the incoming stream and look for calls that might be fraudulent.
Send the results to an output sink (storage) that you can analyze for additional insights. In this case, you’ll send the suspicious call data to Azure Blob storage.
Also send the results to an output sink (Power BI) where you can analyze for additional insights. How one can build real time telco fraud detection visualization dashboard in Power BI.

In this tutorial, we use the example of real-time fraud detection based on phone-call data. But the technique we illustrate is also suited for other types of fraud detection, such as credit card fraud or identity theft.

Scenario: Telecommunications and SIM fraud detection in real time

A telecommunications company has a large volume of data for incoming calls. The company wants to detect fraudulent calls in real time so that they can notify customers or shut down service for a specific number. One type of SIM fraud involves multiple calls from the same identity around the same time but in geographically different locations. To detect this type of fraud, the company needs to examine incoming phone records and look for specific patterns—in this case, for calls made around the same time in different countries. Any phone records that fall into this category are written to storage for subsequent analysis and also send those results to an output sink (Power BI) where one can analyze for additional insights and helps in real-time fraud detection based on live phone-call data .

I have followed step by step by following above article 1 and article 2, so one should go in details through those articles. Below are some snap from steps I followed:

Now, Streaming Analytics job starts looking for fraudulent calls in the incoming stream. The job also creates the dataset and table in Power BI and starts sending data about the fraudulent calls to them.

Once we finished creating Azure Stream Analytics job and output of that job to Power BI sink table name as ‘Telco_Fraud_Demo’ inside Data and BI Summit 2018 Workspace in Power BI Service. After that one can create real time visualization dashboard in Power BI.

For this just login to Power BI Service, and then under your Workspaces in my case ‘Data and BI Summit 2018 ‘ create dashboard by clicking +Add title tab where you will see Custom streaming Data in REAL-TIME DATA section and then once you select Custom Streaming Data you will see the same output power BI sink table which we had created in Azure Streaming Analytics Job Output

By selecting different visualization Type we can visualize and analyze for additional insights and helps in real-time telco fraud detection based on Streaming dataset.

Also, in near future we can directly connect the dataset as Streaming dataset in near future as per below Power BI feature notice.

Thanks,

Anil Maharjan

Senior BI Engineer | Nepal Power BI User Group Leader

How to create Microsoft Azure SQL Database and Visualize along with Power BI.

This blog is mainly about creating Microsoft Azure SQL DB and visualizing with the help of Power BI Desktop.

Firstly, we need to have a Microsoft Azure subscription in order to create the azure sql database. One can try for free for one month worth $200 azure subscription for free. You can find more on this from below link:

https://azure.microsoft.com/en-us/free/?v=18.03

Then, you need to create Azure SQL database. For this please follow below link which will help us to create Azure SQL database step by step. I have gone through each step in detail.

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-design-first-database

Below are some of steps snap which you will see while creating Azure SQL database.

Meanwhile, It will help if you know more about Database Transaction Units (DTUs) and elastic Database Transaction Units (eDTUs). Once can know more on below link: which helps to figure out the Azure SQL database monthly subscription charges.

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-what-is-a-dtu

Also, one can know more about the elastic database pool.

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-what-is-a-dtu

Once you successfully create the Azure SQL DB then you will see as similar to below snap. Here I have create AzureSQLDB as database name and with AdventureWorks test data sample tables. I have set my server name as anilmaharjan.database.windows.net with 2GB in total disk storage.

After that I tried to connect my Azure SQL database ‘AzureSQLDB ‘ but got the below error. Which means we need to allow client IP address to access the windows azure server SQL DB. So for this we need to add Firewall settings for this . Once success Firewall setting, now you are good to go to connect Power BI Desktop to windows Azure SQL DB you just created.

Do visualization by using Power BI Desktop and then can upload in Power BI cloud service too. Find more on different kind of Power BI visualizations:

https://docs.microsoft.com/en-us/power-bi/power-bi-visualization-types-for-reports-and-q-and-a

Now, you had successfully created Azure SQL database and do different visualization using Power BI . Also, it’s good to see the data explore option with Azure and we can direct query and analysis of Azure SQL database in Azure portal itself. Which is great. One can setup Azure cost management in order to optimize your cloud spend and which is also a quite good feature.

#AzureSQLDatabase ,#WindowsAzure, #PowerBI,In summary, you have successfully setup Azure SQL database and do different kinds of visualization by using Power BI Desktop.

Thanks,

Anil Maharjan

Senior BI Engineer | Nepal Power BI User Group Leader

Happy and excited to be a Program committee member for DATA and BI Summit 2018.

Happy and excited to be a Program committee member for DATA and BI Summit 2018 in Visualize Track focusing on Building and Designing Dashboards and Reports.

Thanks to the DATA and BI Summit 2018 Program committee team for giving me an opportunity to work as a Volunteer Program committee member for upcoming DATA and BI Summit 2018 in Visualize Track focusing on Building and Designing Dashboards and Reports.

I had selected Visualize track (Focus: Building and Designing Dashboards and Reports) and regarding top 10 topics that should be covered in this track at DATA & BI Summit are:

How to get story/insights from DATA using Power BI.
Power BI Desktop and it’s features.
R on Power BI.
Different types of Visualization(bar charts ,trends, scatter plot, Geo-spatial , maps ,drill up, drill down, sub-reports ) we can create just by drag and drop approach and also custom visuals.
Power BI service , dashboards, reports , data sources , APIs.
workspaces , Power apps, how can end users be benefit by using different workspaces and power apps and helps in decision making.
Roles and privileges in different workspaces , apps, reports , dashboard.
scheduling, refresh data source , publishing in web, mail subscription, subscriber different reports , dashboards to different teams and end users.
Q&A , Cortana , mobile power BI app, APIs, Gateways.
Phone Layout, Power Query, Data modeling, Get Apps Microsoft App store, Real time data analysis and analytics.

You can find more about application proposal for Data and BI Summit Program committee. Deadline is 12^th Jan 2018

https://www.pbiusergroup.com/engage/volunteeropportunities/volunteer-opportunity-details?VolunteerOpportunityKey=3791f992-2f6d-4eb7-b558-3ad62022dc74

Also, if you want to speak in this conference then you can find more about call for proposal for DATA and BI Summit below: Deadline is 12^th Jan 2018.

https://www.pbiusergroup.com/engage/volunteeropportunities/volunteer-opportunity-details?VolunteerOpportunityKey=c2bb2d9e-ddab-4be1-9fcd-7204a4e6226d

So What about DATA and BI Summit 2018 ?

Data & BI Summit is hosted by The Power BI User Group (PUG). With over 38,000 members, PUG has established itself as the go-to for Data Professionals and Business Analysts who are eager to collaborate and deepen their expertise in Microsoft business intelligence tools.

DATA and BI Summit is going to be held on 24-26 April 2018 | The Convention Centre Dublin | Dublin, Ireland.

What to expect at the Data & BI Summit:

Exceptional, quality content: Learn how to bring your company through the digital transformation by gaining new understandings of your data and deepening your knowledge of the Microsoft Business Intelligence tools. Products will include: Power BI, PowerApps, Flow, SQL Server, Excel, Azure, D365 and more!
Answers to your questions: Network with the Microsoft Power BI team, dig-in onsite to find immediate answers with industry experts, Data MVPs, and User Group Leaders while taking advantage of the opportunity to engage in interactive sessions, workshops and labs.
Network with your peers: Enjoy countless opportunities to create lasting relationships by connecting and networking with user group peers, partners and Microsoft team members.
Stretch your skill set: Advance your career by learning the latest updates and how they can help you and your business.

You can find more on DATA and BI Summit 2018 by going through below link.

https://www.databisummit.com/home

Thanks,

Anil Maharjan

Senior BI Engineer | Nepal Power BI User Group Leader

SQL Saturday #692 Conference and Nepal Power BI User Group Meetup a big success.

Last Saturday, we conducted SQL Saturday #692 conference and Nepal Power BI User Group Meetup Event in Kathmandu, Nepal successfully on 23rd Dec, 2017.

SQLSaturday#692 conference and Nepal Power BI User Group Meetup Event is free event for a Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence, Power BI and Analytics.

I got a chance again to organize and speak in this great event and it was fun and we share knowledge along with other SQL and Power BI Geeks and also had great opportunity to be a speakers around the world. Thank you all speakers , MVP & members for being part of #SqlSaturday692 #SqlSatNepal #NepalPUG we had a great speakers , MVP from around the world. Such as Shree Prasad Khanal Anil Maharjan Gogula Aryalingam Guy Glantser Jonathan Stewart Deependra Bajracharya Virendra Dibya Tara Shakya

I had given presentation on PowerBI: Data Visualization SQL Saturday with R You can find my slides using below link: http://www.sqlsaturday.com/692/Sessions/Details.aspx?sid=69982

Also, it was my great opportunity to share more about Nepal Power BI User Group along with the community. How one can engage and join the NepalPUG group. Currently, there are few members in Nepal PUG and hope it will grow soon. http://www.pbiusergroup.com/kathmandu

The event was a big success and we had nearly more than 100 participants and the interactions between participants and speakers was really overwhelm.

In future also, we will conduct more Data Platform SQL and Power BI related events again soon. Also, one problem we faced difficult here is not having any Microsoft Office premises in Nepal. It would be great if Microsoft can open up small office premises here in Nepal too. So that we can conduct these kind of Microsoft related conference within Microsoft office. Which will help the Microsoft community to grow further and will help to engage more community members in one place.

Thanks,

Anil Maharjan

Senior BI Engineer | Nepal Power BI User Group Leader

Speaking at SQLSaturday Nepal SQLSaturday#692 and Nepal Power BI User Group Meetup.

Firstly I am happy and excited that I will be speaking at SQLSaturday#692 and Nepal Power BI User Group Meetup on Dec 23 2017. This is my fourth time speaking for these International events and I’m really excited that I will be speaking this time also.

I will be speaking on ‘PowerBI: Data Visualization SQL Saturday with R’ here is my abstract detail:

This session is mainly use to learn more about Power BI and R visualization chart. From this session one can learn how can we make some simple and quick visualization using Power BI desktop taking real SQL Saturday data and publish in PowerBI cloud service and also publish those visualization reports to publicly in web. Also, this session mainly helps to tell the story of SQL Saturday by using Power BI and R visualization chart.

Overall, by using Power BI Visualization how one can find out which SQL Saturday is conducted in which state or country in which year and a particular Day along with total sessions conducted. Also one can find SQL Saturday trends year on year and mostly in which month most of SQL Saturday is conducted as per SQL Saturday data history. So, this session will surely help one to learn regarding Power BI and its capabilities and SQL Saturday Stories.

So, What is SQLSaturday?

SQLSaturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence, Power BI and Analytics.Please register soon as seating is limited, and let friends and colleagues know about the event.

This event will be held on Dec 23 2017 at Hotel Yellow Pagoda, Kantipath, Kathmandu, Nepal.

Please do register and be a part of this great event.

http://www.sqlsaturday.com/692/EventHome.aspx

One can join our local SQL Server User Group ‘Himalayan SQL Server User Group’.

http://www.sqlpassnepal.org/

So, What is PUG?

PUG offers online and in-person communities where you can share best practices, take part in exclusive training opportunities, and connect with other passionate Power BI users from various professions and industries. Get involved in your local user group today, and gain a better understanding of data that will enable you to excel in your role.

One can join our local Power BI User Group ‘Nepal Power BI User Group’

http://www.pbiusergroup.com/kathmandu

Hope to see you there and don’t forget to say hello to me in the event.

Thanks,

Anil Maharjan

Senior BI Engineer

http://np.linkedin.com/in/maharjananil

WELCOME TO NEPAL POWER BI USER GROUP

It’s happy and existing to know that Nepal Power BI User Group has been setup finally 🙂
Welcome all, Feel free to join this User Group.

You can sign up and join Nepal Power BI User group by using below link:

( New Microsoft Power BI User Group Link )

Nepal Power BI User Group – Microsoft Power BI Community

http://www.pbiusergroup.com/kathmandu

We are a group of Power BI users and enthusiasts in Kathmandu, Nepal area, looking to connect with others to have interesting discussions and exchange ideas. We meet quarterly along with Himalayan SQL Server User Group to go over the latest updates to Power BI & SQL, help new users get started, and explore specific topics in detail. All are welcome, from beginners to experts.

Power BI User Groups (PUG): PUG offers online and in-person communities where you can share best practices, take part in exclusive training opportunities, and connect with other passionate Power BI users from various professions and industries. Get involved in your local user group today, and gain a better understanding of data that will enable you to excel in your role.

Connect with Power BI Users in the PUG Exchange where you can instantly share what you’re working on in Power BI and in your local user groups.

To know more about PUG Power BI User Group you can check out below link:

Nepal Power BI User Group – Microsoft Power BI Community ( New Microsoft Power BI User Group Link )

www.pbiusergroup.com/home.

To know more about Himalayan SQL Server User Group you can follow below link:

http://www.sqlpassnepal.org/

Feel free to join Nepal Power BI User group.

Thanks,

Anil Maharjan