Posts

Showing posts from April, 2020

How To Create Automated Forecast From Historic Data

Image
forecast is derived from your historical results. So I’m going to show you how you can quickly grab historic data, consolidate it, and then create a forecast from it, which is still align to your entire data model.  Let’s assume that we already have say some sales information already and we have our  Sales  calculation here.  So we need to find a way to project forward to 2018. We want to work out our sales forecast in 2018. If you look at this filter down on the right-hand side, I’ve actually filtered for only 2018, so we’re only looking at 2018 here. To get in-Depth knowledge on Power BI you can enroll for a live demo on   Power BI online training   Now we create another measure table by clicking on Enter Data and it will give you the option to create a measure table. Let’s call this table  Sales Forecasting . If you can get into the habit of creating these measure tables, it would benefit you immensely in terms of organizing your model.  Next is we create a new me

8 Characteristics Of Successful User Interfaces (UI)

Image
There is a lot of information out there about various interface design techniques and patterns you can use when crafting your user interfaces and websites, solutions to common problems and general usability recommendations. Following guidelines from experts will likely lead you towards creating a good user interface – but what exactly is a good interface? What are the characteristics of an effective user interface? To get in depth knowledge on UI, enrich your skills on  Online ui training Here are 8 things I consider a good user interface needs to be: Clear Concise Familiar Responsive Consistent Attractive Efficient Forgiving Lets take a closer look at each. 1. clear Clarity is the most important element of user interface design. Indeed, the whole purpose of user interface design is to enable people to interact with your system by communicating meaning and function. If people can’t figure out how your application works or where to go on your website they’ll

How to Install MSBI – SSIS, Analysis & Reporting Services using Microsoft Visual Studio

Image
If you want to install Microsoft Business Intelligence (MSBI ) – SSIS , Analysis Services & Reporting Services using latest version of Visual Studio ( at the time of writing blog ), the first thing that you need to do is to Download Visual Studio . To get in depth knowledge on Microsoft business intelligence, enrich your skills on Msbi online training professionals. For people who already have a license to Visual Studio: For SQL Database Projects, install the Data storage and Processing workload for Visual Studio For Analysis Services, Integration Services or Reporting Services projects, install the appropriate extension(s) from the marketplace For people who don’t have a Visual Studio 2019: Install Visual Studio Install the Analysis Services, Integration Services or Reporting Services extension as appropriate We will explore the steps for people who don’t have a Visual Studio licence in detail below so that we don’t face any problem Installation of Visual St