• Home
  • About Us
  • Contact Us
  • Privacy Policy
  • Special Offers
Business Intelligence Info
  • Business Intelligence
    • BI News and Info
    • Big Data
    • Mobile and Cloud
    • Self-Service BI
  • CRM
    • CRM News and Info
    • InfusionSoft
    • Microsoft Dynamics CRM
    • NetSuite
    • OnContact
    • Salesforce
    • Workbooks
  • Data Mining
    • Pentaho
    • Sisense
    • Tableau
    • TIBCO Spotfire
  • Data Warehousing
    • DWH News and Info
    • IBM DB2
    • Microsoft SQL Server
    • Oracle
    • Teradata
  • Predictive Analytics
    • FICO
    • KNIME
    • Mathematica
    • Matlab
    • Minitab
    • RapidMiner
    • Revolution
    • SAP
    • SAS/SPSS
  • Humor

Tag Archives: project

AI project matches brands with relevant Instagram influencers

January 21, 2019   Big Data
 AI project matches brands with relevant Instagram influencers

In some circles, the mere mention of the word “influencer” is enough to elicit groans of protest. True, folks like Kylie Jenner, Kim Kardashian, Felix Kjellberg (i.e., YouTube’s PewDiePie), and others with outsized social media presences might not have spotless reputations, but they’re pretty effective at peddling merchandise to their legions of follows. In a recent survey conducted by Tomoson, the average business makes $ 6.50 for every $ 1 spent on influencer marketing.

The trick, of course, is finding the right ambassadors for a given brand. Artificial intelligence (AI) might hold the key — in a newly published preprint paper on Arxiv.org (“Machine Learning Techniques for Brand-Influencer Matchmaking on the Instagram Social Network“), University of British Columbia researchers describe an AI system that can predict the “most fruitful” partnerships between top social media users and companies.

“Unfortunately, it’s not always easy for small brands to find the right influencer: someone who aligns with their corporate image and has not yet grown in popularity to the point of unaffordability,” they wrote. “[So] we sought to develop a system for brand-influencer matchmaking, harnessing the power and flexibility of modern machine learning techniques.”

To keep things simple, the paper’s authors chose to focus on Instagram influencers. (That’s just as well — in a Linqia study, 92 percent of marketers chose it as the most important platform for influencer marketing.) The researchers built a content analysis tool for user and target brand profiles and collected data from the former with an open source Python tool that downloaded all media — including associated captions and hashtags — uploaded to a user’s account.

For the purposes of experimentation, the paper’s authors scraped a sampling of brand profiles and 20 unique user accounts spanning five themes: dogs, cats, mountains, cars, and pizza. To these, they applied an image classification algorithm (Inception-v3) trained on the ImageNet database in Google’s open source TensorFlow framework, which output a list of the five most likely tags for each image.

Next, the three most likely tags were assembled into a string for each user, which were compiled into a grid. Words were then individually assigned numerical values indicating the frequency of their occurrence in a given profile. Finally, both the influencer and target brand data were fed into a model that spit out suggested matches.

In tests, the AI system performed well. For two target companies competing in the same vertical — Domino’s Pizza and Giordano’s Pizza — it recommended several of the same Instagram influencers but in different orders, demonstrating a degree of nuance in its matchmaking. And for every target brand, it managed to highlight the top influencer by category.

The researchers cautioned that there’s more work to be done, noting that the AI system’s performance has yet to be tested on “less distinct” categories and that its predictions rely on accurate tagging by the image classification algorithm. They also say that the quality of the algorithm’s predictions might be improved with custom parameters and additional Instagram profile metadata, such as the number of followers, average number of likes per post, and so on.

However, they believe that it’s a promising first step toward an automated influencer-finding system that could save businesses time, cash, and a whole lot of headaches.

“The results indicated that our algorithm, when presented with a variety of potential influencer profiles, is able to identify those profiles that are most closely aligned with a particular target brand,” they wrote. “If the wealth of data that exists on social media were to be harnessed, it could … be used to facilitate brand-influencer matchmaking. Not only would this help companies find content creators that align with their brand image, it would also provide an opportunity for the small-time creators to monetize their posts, further encouraging the creation of high-quality future content.”

Let’s block ads! (Why?)

Big Data – VentureBeat

Read More

Expert Interview (Part 2): Kenny Scott on the Final Stages of a Data Management Project

January 3, 2019   Big Data
Expert Interview Part 2 Kenny Scott on the Final Stages of a Data Management Project Expert Interview (Part 2): Kenny Scott on the Final Stages of a Data Management Project
 Expert Interview (Part 2): Kenny Scott on the Final Stages of a Data Management Project

Paige Roberts

January 3, 2019

At the Collibra Data Citizens event in May of this year, Paige Roberts had a chance to speak with Kenny Scott, a data management consultant. In part one of this two part series, Roberts and Scott spoke about some of the challenges that come along with being a data management consultant. Part two focuses on the final stages of a data consultant project and what’s next for Kenny Scott.

Roberts: Going back to where you are now, what stage are you at in the implementation now? Where along the journey are you?

Scott: We started off as a group day on the 1st of January this year after about 18 months as a program. We’ve engaged several parts of the business. We’re recruiting those good people to come in. The next stage is to get them in, get them trained, and do the handover.

Roberts: So you’ve actually pretty much got them going. It’s just a matter of knowledge transfer and making sure that they’ve got people in-house who can continue.

Scott: What I’d like to do is transition into more of a data governance role, and help with ideas and then contribute to the data strategy. IT has the data architecture space and they’ve got the access to Collibra. They do the data models and the governance part of it that we don’t need to do. They handle the data quality and the data governance for our data pool as opposed to data governance as a whole.

Right. Collibra is focused on that whole top level, and Syncsort’s Trillium software is very focused on the quality aspect.

All right. Well, you’re talking about winding this down and you’re doing the hand-off. What do you think you’re going to do next?

At the moment I’d like to get back into a bigger organization. I’d like to get into a car manufacturer, or the utility industry, or aviation, or even maybe the medical field. I want to start looking at different datasets. Somewhere that’s big enough to be invested in the tools, somewhere with innovation, you know?

Yeah.

I’m all for business, and I’m looking for a business value, the business process, the business drivers, and a strong business unit

The whole purpose of the technology is to solve a business problem. If you don’t focus on the business problem first, you’re kind of missing the point.

I’ve seen this happening for years. You want the technology to work for you. This is your business problem, you’re telling us you wouldn’t do it. You’re telling us that we’ve got to use these tools, what you’re saying is, “This is our business requirement. This is the tool we’ve identified. We want you to bring it in and implement it so we can build the processes around it.”

That’s good. You really have to talk to each other. It’s too easy for the technology and the business half to get separated until they’re not even communicating.

It was interesting to hear some of those speeches out there now, and even some of the questions that come up about technology driving the governance. I don’t see that. I see technology having a process requirement to make things efficient by knowing where their catalog is or where their assets are. That’s the driver of governance. That is putting something in that is going to help them deliver the toolsets.

They’re the ones that hurt when it’s not done right. I heard somebody talk about a data quality campaign that had been done at their business, and it saved something like 600,000 pounds. They were wasting all of that money on the marketing campaigns that were never going anywhere.

And that’s fair. I wanted to get to where we are, at the moment, we started to monetize for all of that returned mail. I get figures back for what it costs for returned mail, what it costs for the email campaign so we see what we don’t get back from this.

So you can take that information up to the CEO, and say, “This is why it matters.”

And also since we have a permanent head of data coming in the next month so we can make the transfer and keep the show on the road.

That transfer of knowledge, it’s like there’s a certain degree of knowing what they’re supposed to be doing, and how it’s supposed to work, and you need to move that.

Exactly.

Well, thank you for taking the time to speak with me and I really enjoyed your presentation today.

Thank you very much for your support.

Check out our eBook on 4 ways to measure data quality.

Let’s block ads! (Why?)

Syncsort Blog

Read More

Choosing the Right Microsoft Dynamics Partner Is Critical to Project Success

November 15, 2018   Microsoft Dynamics CRM
CRM Blog Choosing the Right Microsoft Dynamics Partner Is Critical to Project Success

Microsoft Dynamics is an industry leader for business software such as ERP (Enterprise Resource Planning) and CRM (Customer Relationship Management) solutions.

Choosing the right software is important, and no doubt you’ve done your homework and discovered the functionality that will help your business automate, organize, and move ahead.

But once you have short-listed a Microsoft Dynamics solution, an equally important decision will be choosing a partner to work with. A trusted partner will help you with installation, but they should be able to do much more. The right partner can make sure your project stays on track, on budget, and includes the right parameters to help you meet your business goals.

It may seem difficult to choose between various technology partners but doing so is vital to the success of your ERP or CRM project.

Here are five things to look for in a Microsoft Dynamics partner:

1. Do they have expert knowledge of the product?

You’ll want your partner to have extensive knowledge of Microsoft products so they will be able to advise you in your selection. They should understand Microsoft’s history and also the direction in which it is headed so they can help you plan for future growth. Microsoft Dynamics is an established product. Choose a partner that is familiar with the depths of its reporting capabilities, user interface, and customization options.

2. Do they have experience in your industry?

Has your partner worked with other businesses similar to yours? Ask for references and check them out. If your partner has successfully helped others in your business niche, chances are good that they will understand your processes and goals, be familiar with your challenges, and can anticipate your needs. True, every organization is different, but specializing in an industry will have allowed your partner to build a wealth of institutional knowledge that will help them best advise you.

3. Do they have an experienced senior staff and an engaged team?

Project implementations will be successful if the partner’s team is both experienced and passionate about the project. Ask your partner who exactly will be working with you and what are their qualifications. How long have team members been with the company and in the industry?

4. Do they have a positive track record for implementations?

Ask the Dynamics partners you interview to provide you with some facts and figures that indicate their project success rates in terms that are meaningful to you. Find out what percentage of their projects come in on budget. For projects that incurred additional fees, find out what the circumstances were behind the scope creep.

5. Do they have a responsive support plan?

You shouldn’t assume that you will throw a switch on your go-live day and never need help from your partner again. As your organization continues to grow, so will your needs. Perhaps you’ll want new reports or need to add new users. There will eventually be updates and upgrades. And if you need a troubleshooter, it’s nice to know that you can call and get help.

Identifying criteria that is important to you and identifying how the partner compares will help you pick a partner that is capable of delivering to your standards. When it comes down to it, hiring the right partner is partially based on who you like best, who you feel comfortable working with, who you trust.

Since 2001, BroadPoint has been delivering comprehensive business application solutions to our clients. From day one, our team of passionate, seasoned consultants has been focused on one thing: helping our clients focus on their mission by designing and implementing great technology solutions.

Contact our experts at BroadPoint and let us show you how the right technology partner can help your project succeed.

By BroadPoint Technologies, www.broadpoint.net

Let’s block ads! (Why?)

CRM Software Blog | Dynamics 365

Read More

Collaborating for a Successful Dynamics 365 Project

August 26, 2018   Microsoft Dynamics CRM
achievement agreement arms 1068523 300x225 Collaborating for a Successful Dynamics 365 Project

In order for a Microsoft Dynamics 365 project to succeed, it is critical to get input early and often from the key stakeholders. Oftentimes projects are driven from either the business or the IT side of a company. However, the most successful projects have these two sides of the business working together from the start to the completion of the project.

Why don’t companies always have IT and business working side by side? If you take some time to think about this question, it seems a bit rhetorical. Of course, both teams need to provide input based on their unique knowledge bases – however, this often isn’t the case.

Siloed Projects

The desire to conduct projects in a siloed manner can stem from distrust. If teams are meant to work together, the individuals need to share ideas and to trust each other. Some of the mistrust can be a byproduct of failed past projects that were not worked on in tandem. When the business conducts a project without sufficient input from IT, things can be missed.

Here are some examples:

  • Not taking into account the amount of data that needs to be transferred from a legacy system.
  • Not formulating a plan for the data transfer from a legacy system.
  • Not accounting for any integrations with other systems.
  • Security planning.
  • Testing plans.
  • Go Live planning input.
  • Incomplete knowledge regarding IT enterprise planning.

When IT runs a project without significant input from the business, there are also risks:

  • The use cases for Dynamics 365 development are not fully realized as the IT team members don’t use Dynamics 365 in the same way the business does.
  • The IT team may not understand the pain points the Business is trying to address with the build/upgrade.
  • How will success for the project be measured?
  • It is important to understand the strategic vision when implementing the application – the business may own this knowledge.
  • Incomplete knowledge of how training should be delivered.
  • How to win at successful user adoption.

It is not uncommon for Dynamics 365 projects to fail when a business unit tries to lead the project in a siloed fashion. It can be challenging for companies to move to a cooperative development between IT and the Business, but the benefits outweigh the negatives in so many ways. Some of the benefits include: gaining trust between the two areas of the business, less meeting time, less rework and the higher likelihood of creating a product that functions as both groups require.

Benefits to Collaboration

Let’s expand on how having the two groups work on the deliverable can be beneficial. By working together on a project or initiative, the teams can learn to work together. Both groups are stereotypically very different. Oftentimes if you asked the business, they would stereotype IT as moving very slow and methodically and not understanding the needs of the business. If you asked IT, they might say the Business can be very reactive and lacks an understanding of what needs to be done to the IT infrastructure to get what they need built. If the two groups are encouraged and allowed to work together, they can learn about each group’s needs and requirements.

When these teams better understand each other’s requirements, this can promote a better working relationship in the long run. The teams can learn the facts behind the stereotypes to hopefully promote a more productive and successful working environment. It can lead to a solid partnership with shared goals, metrics, and deep collaboration.

Collaborating for a Successful Project

It is imperative for the two groups to start working together on the vision for the Dynamics 365 build from the inception, and all team roles should be represented. For instance, it is tempting to try to save on budget and try to roll in certain team members later in the project such as the quality assurance (QA) and training resources. This can backfire and the cadence of the project is affected when the project has to pause to catch up the late joiners.

Another very important requirement is to get input from the business users that will use Dynamics 365 on a daily basis. The team needs to understand what their roles are and how they will use Dynamics 365. This will allow the team to capture all use cases and to provide innovative input. Consultants need to understand the business in order to be consultative. They also need to understand the vision for the future. This helps them to create a backlog and to help guide the project through the first phase. If we tried to build a system that is perfect from the start, we would never get to a state to release the build.

Saving Time with Collaboration

Let’s take some time to talk about the possible time savings by having a collaborative project team. When demos are presented to the entire team, all members can give input and a discussion can occur. Team members can hear pros and cons from both teams and better understand the direction the team chooses to follow. Instead of showing the build to IT and then to the business – it is done at the same time, which allows for decisions to actually be made sooner. The stakeholder(s) in the project can serve as a “tie-breaker” if there are decisions that need to be made.

Agile Methodology

When we talk about a “demo”, we are assuming that the project is following an agile methodology. Agile development definitely has pros and cons. Not all companies can or want to adopt this methodology as it can sometimes increase costs due to the need for more meetings. That said, agile development does allow the project team to see progress and to provide input through each of the development stages. So if the project is headed in a direction that the company did not intend, it can be righted before the project is done. Of course, the stakeholders need to remain engaged for the entire process for this to occur.

Improved Transparency

By having a collaborative team with high stakeholder involvement, there is better transparency for the project. If the project gets behind in development, it is visible right away to the stakeholders. This was the stakeholders can provide input on feature prioritizations. When it comes time to prioritize the backlog, they have the knowledge and background to do this, as they have been involved in the project from the start. For example, if there is a change in business needs for the company, the stakeholders can re-prioritize what the team works on.

In the end, a collaborative team with the right members can produce a Dynamics 365 environment that is useful to the company. Both IT and the Business have knowledge of how it was developed and why. They will also understand what is in the backlog for the next phase, and when it is time to start on the next phase, they can move forward. The team will be accustomed to working together and can successfully start another phase of the project.

Need help on your next Dynamics 365 project? From implementation to support to training – we can help! Contact us today.

Happy Dynamics 365’ing!

Let’s block ads! (Why?)

PowerObjects- Bringing Focus to Dynamics CRM

Read More

Project Flogo: From IoT to Machine Learning

June 21, 2018   TIBCO Spotfire
flogo light 02 Project Flogo: From IoT to Machine Learning

























Integration

Let’s block ads! (Why?)

The TIBCO Blog

Read More

Microsoft launches Project Brainwave for deep learning acceleration in preview

May 8, 2018   Big Data

Microsoft today announced that Project Brainwave, its system for running AI models with specialized chips, is now available in preview on Azure. Brainwave allows developers to deploy machine learning models onto programmable silicon and achieve high performance beyond what they’d be able to get from a CPU or GPU. Microsoft claims Project Brainwave makes Azure the fastest cloud to run real-time AI today.

Brainwave uses specialized field programmable gate array (FPGA) chips to achieve its speed and low latency, and Brainwave on Azure will use Intel Stratix 10 chips and be able to support ResNet50-based neural networks.

Microsoft first revealed its use of Brainwave for serving AI models last summer, and in March said it’s being used to make AI that powers Bing search results 10 times faster.

The news was announced onstage at Build, the Microsoft annual developer conference being held May 7-9 at the Washington State Convention Center in Seattle, Washington.

Also announced today were updates to Azure Bot Service and IoT Edge, a Speech Devices SDK, a $ 25 million initiative to support the creation of AI for people with disabilities, and Amazon joined Microsoft onstage for a demonstration of how Cortana and Alexa will work together.

 Microsoft launches Project Brainwave for deep learning acceleration in preview

Let’s block ads! (Why?)

Big Data – VentureBeat

Read More

The Great Function Project – Part 3

April 25, 2018   Self-Service BI

Function Project Part 3 Banner 1024x581 The Great Function Project – Part 3

Another great trilogy comes to an end… well at least until the next one comes out.

If you haven’t “seen” part 1 & part 2, go back and check those out in sequence. We’re two-thirds of the way through a co-development project to build a complete reference of every DAX, Excel & M function available to you. In part 3 today, we’re finishing it out by adding the NKOTB into the mix – M.

Yeah, M has its challenges when you’re starting out with it… Search Engine utilization being just one of them. We’ll resolve that one today so that you’ll never need to search for an M function again.

Lack of Intellisense when writing M is another major one. Just like DAX and Excel, there is an expected syntax to M, but Power BI is not going to help you out with this – yet. We’re also going to improve that situation too by getting you definitions and examples of many of the functions.

Sounds good? Let’s go.
So click Edit Queries to enter the Power Query Editor, and we’ll get started.

2018 04 14 15 11 00 The Great Function Project Excel Power BI Desktop thumb The Great Function Project – Part 3

The M Formula Bar is disabled by default, so make sure you have it enabled. If you don’t see it go to the View menu, then check the box on the left that says Formula Bar.

2018 04 14 15 17 18 The Great Function Project Excel Power Query Editor thumb The Great Function Project – Part 3

Go to New Source –> Blank Query

2018 04 14 1536 thumb The Great Function Project – Part 3

Not all M is going to be this easy, but this one will be a good confidence builder wlEmoticon winkingsmile 1 The Great Function Project – Part 3.  Go to the Formula bar and tweet write:

Yep, that’s it. One case-sensitive word gets you the complete library of M Functions – and some extras we’re not interested in right now.

2018 04 14 16 21 57 778 Practice Test Questions.xlsx Saved thumb The Great Function Project – Part 3

A list of names isn’t enough you say? Well, aren’t you getting a little spoiled now? OK, OK. We can do this, but to get the rest of the metadata that I know you want, that will mean writing a few custom M columns and doing a little cleanup. It’s about a 10 step process, so for the sake of time, we’ll take a shortcut and you can reverse engineer the details of this query once we’re done (spoiler: Value.Metadata is the magic function).

Go to Home –> Advanced Editor

2018 04 14 23 07 25 The Great Function Project Excel Power Query Editor thumb The Great Function Project – Part 3

Then copy the below code over whatever you have appearing in the Advanced Editor window then hit OK.

let
Source = #shared,
#”Converted List to Table” = Record.ToTable(Source),
#”Added Type Column” = Table.AddColumn(#”Converted List to Table”, “ValueType”, each Value.Type([Value])),
#”Is this row a function?” = Table.AddColumn(#”Added Type Column”, “Is Function?”, each Type.Is([ValueType], type function)),
#”METADATA!” = Table.AddColumn(#”Is this row a function?”, “GoodStuff”, each Value.Metadata([ValueType])),
#”Show me the Metadata” = Table.ExpandRecordColumn(#”METADATA!”, “GoodStuff”, {“Documentation.Name “Documentation.Description”, “Documentation.LongDescription”, “Documentation.Category”, “Documentation.Examples”, “Documentation.DisplayName”, “Documentation.Caption”}, {“Documentation.Name”, “Documentation.Description”, “Documentation.LongDescription”, “Documentation.Category”, “Documentation.Examples”, “Documentation.DisplayName”, “Documentation.Caption”}),

#”If there is more than one example take the first one” = Table.AddColumn(#”Show me the Metadata”, “Examples”, each try if Type.Is(Value.Type([Documentation.Examples]), type record) then [Documentation.Examples] else List.First([Documentation.Examples]) otherwise null),
#”Show me the examples” = Table.ExpandRecordColumn(#”If there is more than one example take the first one”, “Examples”, {“Description”, “Code”, “Result”}, {“Description”, “Code”, “Result”}),
#”Renamed Columns” = Table.RenameColumns(#”Show me the examples”,{{“Name”, “Function name”}, {“Code”, “Example Code”}, {“Result”, “Example Output”}, {“Documentation.Description”, “Short Description”}, {“Documentation.LongDescription”, “Long Description”}, {“Documentation.Name”, “Documentation Name”}, {“Documentation.Category”, “Category”}, {“Documentation.DisplayName”, “Documentation DisplayName”}, {“Documentation.Caption”, “Documentation Caption”}, {“Description”, “Example Description”}}),
#”Filter out non-functions” = Table.SelectRows(#”Renamed Columns”, each ([#”Is Function?”] = true)),
#”Removed Columns” = Table.RemoveColumns(#”Filter out non-functions”,{“Value”, “ValueType”, “Documentation.Examples”, “Is Function?”}),
#”Added Alt Category” = Table.AddColumn(#”Removed Columns”, “Alt Category”, each Text.BeforeDelimiter([Function name], “.”), type text),
#”Added Subcategory” = Table.AddColumn(#”Added Alt Category”, “Subcategory”, each Text.AfterDelimiter([Function name], “.”), type text),
#”Replaced Value” = Table.ReplaceValue(#”Added Subcategory”,””,””,Replacer.ReplaceText,{“Long Description”}),
#”Replaced Value1″ = Table.ReplaceValue(#”Replaced Value”,”
”,””,Replacer.ReplaceText,{“Long Description”}),
#”Replaced Value2″ = Table.ReplaceValue(#”Replaced Value1″,”

    ”,””,Replacer.ReplaceText,{“Long Description”}),
    #”Replaced Value3″ = Table.ReplaceValue(#”Replaced Value2″,”
  • ”,””,Replacer.ReplaceText,{“Long Description”}),
    #”Replaced Value4″ = Table.ReplaceValue(#”Replaced Value3″,”

”,””,Replacer.ReplaceText,{“Long Description”}),
#”Replaced Value5″ = Table.ReplaceValue(#”Replaced Value4″,”</li>”,””,Replacer.ReplaceText,{“Long Description”})
in

#”Replaced Value5″”, “Documentation.Description”, “Documentation.LongDescription”, “Documentation.Category”, “Documentation.Examples”, “Documentation.DisplayName”, “Documentation.Caption”}, {“Documentation.Name”, “Documentation.Description”, “Documentation.LongDescription”, “Documentation.Category”, “Documentation.Examples”, “Documentation.DisplayName”, “Documentation.Caption”}),
#”If there is more than one example take the first one” = Table.AddColumn(#”Show me the Metadata”, “Examples”, each try if Type.Is(Value.Type([Documentation.Examples]), type record) then [Documentation.Examples] else List.First([Documentation.Examples]) otherwise null),
#”Show me the examples” = Table.ExpandRecordColumn(#”If there is more than one example take the first one”, “Examples”, {“Description”, “Code”, “Result”}, {“Description”, “Code”, “Result”}),
#”Renamed Columns” = Table.RenameColumns(#”Show me the examples”,{{“Name”, “Function name”}, {“Code”, “Example Code”}, {“Result”, “Example Output”}, {“Documentation.Description”, “Short Description”}, {“Documentation.LongDescription”, “Long Description”}, {“Documentation.Name”, “Documentation Name”}, {“Documentation.Category”, “Category”}, {“Documentation.DisplayName”, “Documentation DisplayName”}, {“Documentation.Caption”, “Documentation Caption”}, {“Description”, “Example Description”}}),
#”Filter out non-functions” = Table.SelectRows(#”Renamed Columns”, each ([#”Is Function?”] = true)),
#”Removed Columns” = Table.RemoveColumns(#”Filter out non-functions”,{“Value”, “ValueType”, “Documentation.Examples”, “Is Function?”}),
#”Added Alt Category” = Table.AddColumn(#”Removed Columns”, “Alt Category”, each Text.BeforeDelimiter([Function name], “.”), type text),
#”Added Subcategory” = Table.AddColumn(#”Added Alt Category”, “Subcategory”, each Text.AfterDelimiter([Function name], “.”), type text),
#”Replaced Value” = Table.ReplaceValue(#”Added Subcategory”,””,””,Replacer.ReplaceText,{“Long Description”}),
#”Replaced Value1″ = Table.ReplaceValue(#”Replaced Value”,”
”,””,Replacer.ReplaceText,{“Long Description”}),
#”Replaced Value2″ = Table.ReplaceValue(#”Replaced Value1″,”

    ”,””,Replacer.ReplaceText,{“Long Description”}),
    #”Replaced Value3″ = Table.ReplaceValue(#”Replaced Value2″,”
  • ”,””,Replacer.ReplaceText,{“Long Description”}),
    #”Replaced Value4″ = Table.ReplaceValue(#”Replaced Value3″,”

”,””,Replacer.ReplaceText,{“Long Description”}),
#”Replaced Value5″ = Table.ReplaceValue(#”Replaced Value4″,”</li>”,””,Replacer.ReplaceText,{“Long Description”})
in
#”Replaced Value5″

And now you have a complete listing of 674 M functions along with a decent amount of the associated metadata! There are a total of 12 M functions being used in this query (highlighted yellow) and you now have the resource to take a closer look at what they do.

2018 04 15 21 43 18 The Great Function Project M Power BI Desktop thumb The Great Function Project – Part 3

Bringing It All Together (Optional Exercise in Futility)

We’ve already created a lookup table to cross-reference DAX & Excel in Part 1. There’s no reason why we can’t add M to that lookup table, even though there is zero overlap.

You’re probably going to run into errors at this step or on the refresh of the Function Lookup Table. The DAX query from part 1 is going to be the culprit. You’ll need to re-run DAX Studio and update the DAX query Source step with both the new local host and new catalog_name fields following the steps from part one here or here.

To update your Function Lookup Table with the M functions.

1 – Select the Function Lookup Query you created in Part 2
2 – Click the gear icon on step 2 of the query ‘Appended Query’
3 – Change the default Append Query behavior from appending ‘Two tables’ to ‘Three or More tables.’
4 – Select the M table
5 – Click Add to now combine DAX, Excel & M

2018 04 14 23 56 00 Microsoft Edge thumb The Great Function Project – Part 3

And we’re done. Hit close and apply and proceed to layout your complete Power BI & Excel reference in any way that works for you!

Let’s recap what WE covered in the Great Function Project:

We queried the metadata of a PBIX file (twice) even writing a little T-SQL along the way.

We used DAX Studio.

We connected to SQL Server Analysis Services.

We built a web scraping application.

We performed some ETL – indirectly writing M in the process.

We created a dynamic lookup table driven my 3 separate fact tables.

We have written M and we’ve also “borrowed” some, both of which are fine.

….and you have done this using a free application with no traditional data sources in (hopefully) less than 30 minutes total!

As much as this project was building up to the end product, we sure did get some reps in a lot of different techniques along the way! If any of this is new to you, I hope it’s demystified a few things for you.

Please download the .pbix for your reference here

I’d also LOVE to hear how you put your workbook to use and would love to see what you’ve put together. Feel free to share it with me [email protected]

We like to think that is no accident.  We’re different.  First of a new breed – the kind who can speak tech, biz, and human all at the same time.

Want this kind of readily-absorbable, human-oriented Power BI instruction for your team? Hire us for a private training at your facility, OR attend one of our public workshops!

Let’s block ads! (Why?)

PowerPivotPro

Read More

Managing Project Scope

April 12, 2018   Microsoft Dynamics CRM
shutterstock 590486021 300x225 Managing Project Scope

To be or not to be…. That is a scope question.

Have you ever been on a project and been faced with the decision of whether something should be part of the project or not? Often times, people see this as a single decision or perhaps more commonly, maybe two.

Many Project Managers assert that there are several decisions you should make when defining whether something is a part of project scope. The value of asking these questions is that they reduce the chances of scope creep, help harden your project documentation, and help you include key decision makers in changes to the project.

Let’s walk through this process to see what it looks like! (Reference the diagram below).

041118 1509 ManagingPro1 Managing Project Scope

Obviously, the starting point is that there is ambiguity around whether something is included in the current project scope.

Your first decision is to define if it is indeed in the existing project scope or not. Typically, you would refer to the Statement of Work, Project Charter, or other organizational scope document. If you’re unable to resolve this question by referencing one or multiple project documents, then you may need to revisit your documentation as it may lack the detail to adequately define and help manage scope now and moving forward. Identifying this issue early in a project will help mitigate one of the most common issues, which is “scope creep.” Often the most common cause of scope creep is that scope was not well defined and documented at the beginning of a project.

If the proposed item is defined as not being in scope, then you need to determine if you should increase the current project scope to include it. This is the most common path for project changes, and results in either a project scope change, or pushing the item to a later date or dropping it entirely.

If the proposed item is within scope, your next decision should be if it is worth including in the existing project NOW.

Typically, this question is not asked as a part of the process. Usually once an item is defined as being within scope, it is immediately assumed that it is included in current scope without any real vetting of the impact or value of the addition.

Asking this question has some key benefits. The first benefit is that it helps you understand where this item came from and why it changed. If it is a something that was missed, then it may highlight that there could be more items like this now or in the future. If this was a change, then there is the possibility it may change again which means you need to understand now so you can plan appropriately. All too often project scope expands because changes are included without effectively defining the extent those changes will have on an entire project and not just on a specific project item.

The other benefit of asking this question is that you engage key stakeholders in defining whether something should be in the current project. As a part of this process, you must clearly define the value of these items. This will aide in the later steps of getting more resources or time to complete the work if it is added to the current project.

If it is worth including now, then the follow-up question should be if you could adjust or cut current scope or just add it in. This is another question that is rarely asked, but can help mitigate change orders that increase cost, project duration, and needed resources. Sometimes project or organization constraints force the question of one item taking the place of another instead of just adding it in. Projects can sometimes grow exponentially in scope and end up being nearly two or three times what was initially planned. This results in significant cost and duration increases that are perceived as poor project or program management when the true root cause was poor project scoping at the beginning of the project.

If you determine that is it not worth including now, then you should move that item to a later phase, put it onto the backlog, or move it to another project. Often this is for items that will change again or items whose scope you’re unable to adequately define now. In most cases, items that are pushed out usually change significantly or end up being dropped all together. One key advantage of asking this question beyond managing scope is that you engage the business on the value of adding something to the project scope.

When you follow this process you ensure that you have tried your hardest to mitigate scope creep, have determined if everything in scope is ‘value added,’ as well as making sure all stakeholders are aware of how and why project scope changed along with any changes in budget, duration, and resources.

Looking for more helpful guides to Dynamics 365? Be sure to subscribe to our blog!

Happy Dynamics 365’ing!

Let’s block ads! (Why?)

PowerObjects- Bringing Focus to Dynamics CRM

Read More

Organizational Units with Dynamics 365 for Project Service Automation

April 7, 2018   Microsoft Dynamics CRM
Project Management 300x225 Organizational Units with Dynamics 365 for Project Service Automation

Microsoft released an end-to-end solution to manage projects within Microsoft Dynamics 365 for Project Service Automation (PSA). Professional Services firms can track their projects from sales to delivery and invoicing. To fully use its capabilities, new components must be configured. Let’s get familiar with the terms!

Business Units vs Organizational Units: What’s the difference?

If you’ve been around Microsoft Dynamics 365, you may already be familiar with Business Units: the basis of the security structure per your organization. If you are a new to this, that’s ok too. You can learn more about Business Units here.

When configuring PSA, you must first consider the levels of access a division needs; as you would normally do with Microsoft Dynamics 365. This will help you define your Business Units. Then, consider the costs related to running a division of your professional services firm. Does using a billable resource from “Division A” instead of a billable resource from “Division B” affect the cost of delivering a project? Is there a difference even if they have the same role/position? If it does, now we are talking about Organizational Units.

040318 2037 Organizatio1 Organizational Units with Dynamics 365 for Project Service Automation

These divisions, or Organizational Units above, are how your company is organized, either by locations, functions, or any other factor. The one thing to look for is security for Business Units and costs for Organizational Units.

How to Create an Organization Unit

Once you define your divisions, you are ready to create an Organizational Unit as follows:

1. In your Dynamics 365 portal, go to Project Service and select Organizational units.

040318 2037 Organizatio2 Organizational Units with Dynamics 365 for Project Service Automation

2. Click New.

040318 2037 Organizatio3 Organizational Units with Dynamics 365 for Project Service Automation

3. Complete the General information area per the division you want to create.

040318 2037 Organizatio4 Organizational Units with Dynamics 365 for Project Service Automation

  • Name
    (required): provide a meaningful name to easily identify the division
  • Description (optional): include a brief description to later remember what the name means
  • Currency (required): add the currency used to run the business within the division. Great for global companies with different divisions using the currency of their respective location. Yes, you’ll create an organizational unit for each!

4. Save your Organizational Unit to create the record, and continue.

5. Add a Cost Price List by clicking “+” on Cost Price Lists.

040318 2037 Organizatio5 Organizational Units with Dynamics 365 for Project Service Automation

6. Click the magnifying glass to search for a Cost Price List.

040318 2037 Organizatio6 Organizational Units with Dynamics 365 for Project Service Automation

7. Select a Cost Price List from the records shown or scroll-down to look for more.

040318 2037 Organizatio7 Organizational Units with Dynamics 365 for Project Service Automation

NOTE: At the beginning, you might not have a Cost Price List to add. Yet, every organizational unit should have at least one cost price list associated. Once you have created a Cost Price List record with the roles and expenses costs usually incurred by the division, return to the organizational unit record. Remember, this price list must have the cost context, and the same currency as the organizational unit your updating.

8. Close the record by clicking Save & Close.

Each company is different and so is the number of Organizational Units needed to set up your Microsoft Dynamics 365 for Project Service Automation. From smaller companies with only one, to companies with multiple organizational units to meet their complex structure and global businesses – no number of Organizational Units is better than the other. The best configuration is one that fits your business.

Learn more about Dynamics 365 for Project Service Automation here.

Happy Dynamics 365’ing!

Let’s block ads! (Why?)

PowerObjects- Bringing Focus to Dynamics CRM

Read More

The Great Function Project – Part 2

April 5, 2018   Self-Service BI

Function Part 2 1024x581 The Great Function Project – Part 2

My name is Mathew Herring Jack, and I am a member of Traditional Excel Users Anonymous.

As a Traditional Excel User, I could not stop copying and pasting downloaded reports. Even when my manager diagnosed me with inaccurate month-end reporting, I could not stop using external workbook links. I admitted my reckless use of nested IF statements was hurting others, yet I knew I would do it again. I still don’t know why I needed to type FALSE at the end of my VLOOKUP’s – it makes no sense.

ab3c59ff2b17dbafcb50c98c988d9f62 The Great Function Project – Part 2

Yet, here I am today, using Excel as much as almost anyone on the planet, now many years SUMPRODUCT free.I almost never use the CTRL key anymore. In fact, I use the mouse a LOT in Excel now. A Traditional Excel User could never admit such a thing.

How is it possible to still be here today saying that I am an Excel expert and yet I don’t even use the formula bar anymore!

I found a way out. By following the 28-step program as described in the Big Book of Traditional Excel Users Anonymous and living in the disciplines of DAX and M every day, I can remain abstinent from Traditional Excel and the allure of absolute referencing.

I now know how to live without Traditional Excel. The compulsion to show off even my array formulas has been removed. My progressive illness has been arrested. My disease has been put into remission. I now dedicate my life to traveling the country helping others recover from the affliction… See you in Boston!

And Back To Your Regular Scheduled “Programming”

Today we’re revisiting my gateway drug, and we’re going to use the Power BI web connector to import every Excel Function to go alongside the DAX reference we built in part 1 of The Great Function Project.

If you missed part 1, go back and follow the steps. It should take all of about 5 minutes to get caught up. Part 2 should only take 5-10 minutes on top of that.

The general idea is that we’re together co-developing a Power BI reference that contains information on every DAX, Excel and M function available. We’ll analyze the similarities and differences between the three languages and will leave you with a useful resource to help you and your organization transition from Traditional Excel to Modern Excel.

If you did follow along with Part 1, re-open your workbook and insert coin to continue.

Web Scraping? Sounds Painful

Not everyone wants their online content harvested, but if you want to enrich your data model, there is a vast data source that you might be ignoring – the web. Need performance reporting adjusted from the population? Can do. Want to quantify the impact of a Patriots win on your Sunday sales? There’s a source for that.

Need every Excel function available? Check this link out. 

2018 03 24 15 10 19 DVprectable.txt.xlsx Excel thumb The Great Function Project – Part 2

Scroll down the page and look at all 471 of those Excel functions! Your scrolling finger is getting sore? OK then, I have a better idea. Let’s use this page as a data source and save it in Power BI for later.

Go to Get Data –> Web

2018 03 24 1504 thumb The Great Function Project – Part 2

Paste this url into the next screen and hit OK.

https://support.office.com/en-us/article/excel-functions-alphabetical-b3944572-255d-4efb-bb96-c6d90033e188

2018 03 24 1505 thumb The Great Function Project – Part 2

Power BI looked at that webpage and what it found were two important elements – Document and Table 0. Table 0 looks to have all the good information in it, so check the box next to it and hit ‘Edit.’

2018 02 27 14 39 04 The Great Function Project Excel Power BI Desktop thumb The Great Function Project – Part 2

Commence Right Clicking

Rename your new Query to Excel and let’s do a little data cleanup… The goal here is to have three columns – Function Name, Function Group and Function Description AND to have Function Name is a similar enough format to the DAX Query that later on we’ll be able to link them together by a relationship.

.2018 03 24 15 34 38 2018 03 24 15 34 12 The Great Function Project DAX Power Query Editor thumb The Great Function Project – Part 2

1) Right click on Function Name column and select ‘Replace Values.’ Enter “ function” in as the Value To Find – note the space preceding the word ‘function.’ Hit OK.

2018 03 24 15 45 40 The Great Function Project DAX Power Query Editor thumb The Great Function Project – Part 2

2) Right-click on the ‘Type and description’ column and select Split Column –> By Delimiter. Select ‘Colon’ as the delimiter and check the ‘Left-most delimiter’ button. Hit OK.

2018 03 24 15 49 53  thumb The Great Function Project – Part 2

Looking better, but happiness has not been achieved. More right-clicking is necessary. 2018 03 24 16 00 21 The Great Function Project DAX Power Query Editor thumb The Great Function Project – Part 2

3) Right-click column ‘Type and description.1’ and select Rename Columns. Rename to ‘Function Group.’ Right-click column ‘Type and description.2’ and select Rename Columns. Rename to ‘Excel Function Description.’

4) Right-click the ‘Excel Function Description’ column and select Transform –> Trim. This will get rid of spaces at the beginning or end of the column.

Excel – The Gateway Drug

I was a Finance guy. You wanted a business model? I could do that. Need a merger model to bolt onto that? I could do that too. Need a GAAP-compliant quarterly financial statement consolidations package that integrated with Word? Give me a few days. Traditional Excel put beer in my fridge for 15 years.

I’m not someone who’ll necessarily step outside my comfort zone. If I’m pushed outside of it, then I’ll run with it and thank you later. But in 2012, nobody was going to push me out of my Excel comfort zone. DAX was around, but let’s just say that its existence wasn’t well known, let alone how to find it.

So lucky for me, there was a lot of overlap between DAX and Excel – I didn’t need to step out of my comfort zone.

How much overlap EXACTLY though? Well, let’s find out… we’ll need to create a lookup table between our DAX and Excel tables.

Right-click on the DAX query from Part 1 and select ’Reference.’ Then rename that new query to ‘Function Lookup Table.’

2018 03 24 1658 thumb1 thumb thumb The Great Function Project – Part 2

Before we do the next step, go back and make sure that you have a column named ‘Function Name’ in both your DAX Query and your Excel Query. As a reminder, Power Query is case sensitive, so it needs to be exactly the same in both. My queries looked like this:

DAX Query

2018 03 25 23 01 50 The Great Function Project Excel Power Query Editor thumb1 thumb The Great Function Project – Part 2

Excel Query

2018 03 25 23 02 15 The Great Function Project Excel Power Query Editor thumb2 thumb The Great Function Project – Part 2

Now left click on Append Queries in the top right. Then select Excel from the drop-down menu Table to Append. If you get a message about Privacy settings just check ‘Ignore’ and move on.

2018 03 24 17 01 44 The Great Function Project DAX Power Query Editor thumb1 thumb thumb The Great Function Project – Part 2

You should now have a table that looks something like this:

2018 03 24 17 08 55 DVprectable.txt.xlsx Excel thumb1 thumb thumb The Great Function Project – Part 2

This is more information than we need for the basic lookup table we are aiming for here.

Right Click on the Function Name column and select ‘Remove Other Columns,’ ’then right click again and select Remove Duplicates and now you have the most vanilla lookup table possible.

2018 03 25 23 20 36 The Great Function Project Excel Power Query Editor thumb thumb The Great Function Project – Part 2

Hit ‘Close and Apply’ and Power BI will likely create the relationships for you, but if not just replicate this structure, creating the relationship using the Function Name columns..

2018 03 25 23 26 08 The Great Function Project Excel Power BI Desktop thumb3 thumb The Great Function Project – Part 2

Finally, time to write some DAX.

# of DAX Functions =
COUNTROWS ( ‘DAX’ )

# of Excel Functions =
COUNTROWS ( Excel )

# of Functions in Both DAX & Excel =
CALCULATE (
    COUNTROWS ( ‘Function Lookup Table’ ),
    FILTER (
‘Function Lookup Table’,
[# of Excel Functions] = 1
&& [# of DAX Functions] = 1
    )
)

% of DAX already in Excel =
DIVIDE ( [# of Functions in Both DAX & Excel], [# of DAX Functions])

And there we have our answer, 48.09% of the DAX language was already present in Excel.

Now, this doesn’t tell the whole story at all, but regardless of the numbers, getting started with DAX is within the comfort zone of anyone that’s written a SUM in Excel and lived to tell the tale.

Excel isn’t going anywhere as the world’s most used BI tool – but in the years to come in might just be used a little less…. traditionally.

As for Power BI, in my opinion, this extensibility is what drives it “from nowhere to being the leader in BI in the cloud”  with “a $ 500 million annualized billings run rate for its 2018 fiscal year”. Achieving these milestones is a lot easier when 1 billion people already know 48.09% of your new product’s language.

Next up in the series is M…. I’ll be posting that on Tuesday 17th April. The lack of intellisense in M is was the primary reason I started the Great Function Project, so it’s kind of the Grand Finale.

We like to think that is no accident.  We’re different.  First of a new breed – the kind who can speak tech, biz, and human all at the same time.

Want this kind of readily-absorbable, human-oriented Power BI instruction for your team? Hire us for a private training at your facility, OR attend one of our public workshops!

Let’s block ads! (Why?)

PowerPivotPro

Read More
« Older posts
  • Recent Posts

    • Software Companies Still Navigating the New ASC 606 Standards
    • Deploy Anywhere, Manage Everywhere with Cloud-Native Mashery
    • will Individual-1's reign passing be as funny as “the Death of Stalin”
    • OpenAI: Social science, not just computer science, is critical for AI
    • Some OData Tips
  • Categories

  • Archives

    • February 2019
    • January 2019
    • December 2018
    • November 2018
    • October 2018
    • September 2018
    • August 2018
    • July 2018
    • June 2018
    • May 2018
    • April 2018
    • March 2018
    • February 2018
    • January 2018
    • December 2017
    • November 2017
    • October 2017
    • September 2017
    • August 2017
    • July 2017
    • June 2017
    • May 2017
    • April 2017
    • March 2017
    • February 2017
    • January 2017
    • December 2016
    • November 2016
    • October 2016
    • September 2016
    • August 2016
    • July 2016
    • June 2016
    • May 2016
    • April 2016
    • March 2016
    • February 2016
    • January 2016
    • December 2015
    • November 2015
    • October 2015
    • September 2015
    • August 2015
    • July 2015
    • June 2015
    • May 2015
    • April 2015
    • March 2015
    • February 2015
    • January 2015
    • December 2014
    • November 2014
© 2019 Business Intelligence Info
Power BI Training | G Com Solutions Limited